l don't know if Trek will really ever show or address the concept.
Trek seems to have a certain reservation with showing direct homosexuality.
You can find some surprising hidden messages in some episodes.
Like the TNG one where Beverly finds out that her Trill lover's new host body is a female.
Before she smiled when Worf told her the host had arrived. Then she frowned when she saw it was female.
She obviously wasn't into women, which was her right-too bad Trek never explored differences in preferences in the 24th century to explain her reaction.