The devastating result leaves Trump politically hamstrung as he enters the remaining two-year 'lame duck' period of his White House tenure