Ambassador's close relationship with the PM and willingness to bet it all on Trump paid handsome dividends, but many on other side of aisle say strategy will haunt Israel