According to the noise made by the small but vocal LGBTQ+ community, we all should be wearing rainbow-coloured underpants. But accepting and embracing the LGBTQ+ community does not mean that we all have to be LGBTQ+.
For many cis-gender, gender-dysphoria (gender identity complexed with gender appearance — not a disease) is not an issue. For many centuries, societies have had to deal with homosexuality and other situations which are not sexually reproductive. Sex for pleasure (or not) has been an on and off taboo subject since before antiquity.