The U.S.-Israel relationship remains one of the most consequential in history, and its slow depletion — evidenced by poor public opinion — should trouble leaders in both countries.