Accusations of cognitive dissonance are fruitless – there's a sizable block of 'gay conservative Christians' who probably think that you're experiencing cognitive dissonance and that their beliefs make sens given their worldview.
I can understand how this system of beliefs could seamlessly cohere in the minds of children or proto-humans. Thiel, and the rare others like him, are harder to fathom.
But you're ignoring that Hillary Clinton was campaigning against gay marriage from 1991-2013, basically up until the Supreme Court made the issue moot. It was Bill Clinton, with 3/4 of Congressional Democrats support who signed the Defense of Marriage Act in 1996 -- the last year I considered my self a Democrat.
Not everyone who is a republican is a christian. I happen to be an atheist libertarian.
Putting me in box, labelling it and then insisting that I must be experiencing "cognitive dissonance" if I'm not a democrat is ... not exactly a rational argument.