I prefer that the crew and people of Trek have their free choice and personal preferences too.
I like the idea that individuals are free to do such things in the 24th century, and yet can still respect one another

.
Problem is, Trek treated the subject either very dramatically, or in a analogous, quiet sense-it's never directly mentioned.
I wondered if Trek could have just handled the subject in a direct, funny way.
For example, a character, (alien or otherwise) that obliviously likes men , hits on Picard , and Picard smiling, says something like, "sorry, I really, really, really, like women".
"Oh yes, full bodied buxom women"
That would have made it clear that a lot of people in this time like only a certain gender, but it still comes out funny and innocent.
There were 80's even 70's shows, that surprisingly just went ahead and dealt with the issue such a way.
.