Do most of the Unionist despise him and support Israel?
The Unionists (obviously not all of them) generally support Israel, this is for two reasons.
First the Irish Republicans always received weapons and training from Palestinian terrorists as well as Colonel Qaddafi (a point often overlooked by conservative Irish Americans) so naturally the protestants took to supporting the Israelis. If you travel around Northern Ireland you will frequently know which territory you are in by the flags flying from lamp-posts, Irish Triclour/Palestinian flags: Catholic, British Union Jack/Israeli flags: Protestant.
But the protestants also have a sort of spiritual affinity with the Israelis, regarding themselves as beleaguered little outposts of settlers with a fondness for Old Testament justice among hostile natives, the prods also felt a bit of support for the Afrikaners too back in the day.
Yes.