Most people seem to know a guy who rails against same-sex marriage but loves lesbian porn. The hypocrisy is pointed out, and it’s accurate. That type of attitude is hypocritical and wrong, although I’d say it’s not surprising.
For humans, the disgust and arousal impulses are very similar. It sounds counterintuitive because those feelings seem like opposites, but they stimulate the same part of the brain. That’s why a lot of people do things during sex that they might otherwise think of as “gross.” That’s why fetishes and phobias are often flip sides of the same coin. I learned that when a person has a fetish, it often used to be a phobia. It just happened to transform from a fear into something that intensely arouses the person, either by chance or as a coping method.
When someone is homophobic but also really into watching two women have sex, it’s both a fear and a fetish. Fetishes are usually applied to inanimate objects, whereas lesbians are obviously people, but a homophobe doesn’t see them as people. He sees them as objects he watches and fantasizes about and then rejects in disgust. (Women can definitely be homophobic too, but I’m using a straight man in this example because so many people have aptly brought up the fact that homophobic men who like lesbian porn are hypocrites.)
This can also be seen in politicians who draft anti-gay and anti-trans policies but are then caught having sex with gay and transgender people. If they’re sleeping with someone of the same gender, many people will respond by saying that homophobes are secretly gay. While it’s true that some are closeted and overcompensating, I’d say that it’s more than a matter of just being gay and not wanting the public to know. It’s a combination of fetishization and fear. If they are hostile toward the LGBT community, they are probably not respectful toward the person of the same gender whom they’re involved with. They most likely dehumanize them. And when a homophobic person is immediately assumed to be gay, that can reinforce the idea that gay people are their own worst enemies and that they’re the ones who are really oppressing each other, which absolves straight homophobes of responsibility.