I think the cognitive dissonance is expecting people to be attracted to the sex they aren’t usually attracted to. Humans are nuanced so there will always be exceptions, but it’s unrealistic to expect the exception to be the norm. Most people are gay or straight and exclusively attracted to one sex.