And I'm fine with all that. But again, the setting is two-hundred-plus years in the future when, presumably, the acceptance level will be so high nobody gives it a second thought. Half the country already thinks it's "normal". In fifty years, or even just twenty years from now, all but a few holdouts will think the same way.
What I don't want to see, sadly what I suspect Hollywood writers will give us, are plot lines or sub-plots every-other episode where the LGBT character's orientation becomes an issue of some sort or another, where another crewman says/does something that proves intolerance and therefore must be corrected, or someone misinterprets something that is said and somehow offends the LGBT character, or whatever the message of the month is.
And I also worry about who the casting director picks for the part. As someone up-topic mentioned, there are few likable realistic LGBT characters on TV today. Take the Rusty character on Major Crimes. The whiny teenage angst was bad enough, but after he came-out, every freaking time he was on-screen for the entire next season, it was like getting hit with a hammer as they tried to get their message across. Can you think of a more unsympathetic character to carry the LGBT torch? And yes, that show's producer openly admitted he had/has an agenda.
Star Trek, and sci-fi in general, has a long history of attacking social problems. But it's always done it in a way that doesn't directly use today's events. They dealt with racial bigotry, religious intolerance, drug addition, and a whole host of other issues without once resorting to literally calling out race, religion, etc. etc. etc. Do today's Hollywood writers know how to do that anymore, can they do that with LGBT issues without putting on a rainbow parade? Maybe, but I fear they don't.
Now, I can envision an episode plotline in which they interact with an alien species (Klingons, perhaps??) that don't have (or claim to not have) LGBT people in their society and thus are confused (or offended) by the character's lifestyle. That would be a genuine tactful way of expressing the issue. Done right, it could even be an interesting multi-episode story arc.