Since these characters were introduced people have said what you're saying over and over. Always with the same "I don't have a problem with gay/trans/NB but..." disclaimer. Then they refuse to give examples of the characters doing anything other than existing. This thread is a good example. Please refresh my memory. Which episode(s) focus "on the social issues that surround homosexuality."
Outside of the scene where Adira tells Stamets their pronouns and the use of those pronouns, give me one line, in one scene, in one episode, of one season that would have to be changed if Adira was a cis straight human woman hosting the symbiote of her deceased cis straight Trill boyfriend.
Give me one line, in one scene, in one episode, of one season that would have to be changed if either Stamets or Culber was a woman.
To be clear, although I don't remember any, I'm not saying you couldn't find any examples. I'm just curious what constitutes "forced and obvious" plot elements that are "advertisement(s) for ideologies" that "ruins the show" for you.
Without examples all anyone hears is you bitching about the existence of these characters the way Archie Bunker would have bitched about Uhura simply existing.
So "there were lots of anime which did have official English names," so you didn't "come from an era before widespread official anime translations."
Therefore, bullshit.