No, in cases like theirs surely the fear is primarily fear of getting caught. It may be that for high-profile folk that the thrill of risky behavior is more of a turn-on than the sex, or at least a big part of it.
I think their public homophobia would be more of a smoke screen than anything else.
More generally, I agree with about everything in this thread.
Being obsessed with someone else's sex life, of whatever form, is pretty kinky. One might disapprove of homosexuality, oppose political rights for gays, etc., fairly dispassionately, just as one can rationally entertain a lot of ideas, good or bad. But when it becomes an obsession, then that likely says more about the person than about the people or ideas that the person opposes.