Alliances are about geopolitics as much as how much we like countries' behaviour. Israel is an invaluable intelligence partner in the War on Terror and a natural ally against Iran. They're also the closest thing to a liberal democracy in the Middle East.
As long as the US continues to gain more from its alliance with Israel than it loses, the alliance will endure. No matter how much individual leaders may loathe each other.