That was one of the more interesting SOTU addresses I’ve seen. Personally, I think he said most of the things that needed to be said, and he said them reasonably well. I’m sure he’s going to get some flack for attacking Trump directly (though not by name), but I was frankly glad to see it. Doing otherwise makes it seem like it’s just your typical election/political disagreements, but we’re past that now.
You keep saying everyone else has cognitive dissonance, but you haven’t explained what the actual dissonance is. There’s no reason to assume that supporting Trump and supporting Israel are to dissonant ideas. Both want to destroy something that he’s professed agreement with destroying.