It essentially means the end of the two state solution, which is something the current Israeli Prime Minister Benjamin Netanyahu does not really support,is officially dead.
Even now Trump is trying to have it both ways by also saying in his speech that "We are not taking a position Israeli sovereignty in Jerusalem."