Don't be like that. We're all discussing in good faith here.

Before that happens, Adira spends considerable time with the ghost boyfriend on how would that be received and goes through considerable angst processing it. Before even that it's shown them in considerable anguish to come out to their boyfriend even.

Of that arc, the one thing well executed was the 90 seconds you pointed.

So yeah, most of it shouldn't happen in a welcoming environment in the 25th century. Her adoptive parents had no issue being a gay couple adopting a teenager, in which universe would that teenager ever feel the need to hide their sexuality and insecurities from them? Why the anguish?

It's pretty much established since TNG and DS9 that pansexuality is mainstream. In The Outcast, Riker was involved with a non binary alien; the episode wasn't about the reactions (the crew was absolutely nonchalant about it), with Worf supporting Riker trying to rescue the alien that broke their social customs. You can still send a message with a good in universe justification.

There's no in universe justification for Adira. She doesn't come from a backwards culture, has crazy conservative parents, there's no atavic crewmate around, no aliens taking offense... It's a non conflict. It's bad writing.

To be clear, it's a message that needs to be on TV. But it's a damn shame they did it so poorly when it could easily have been set up to actually create a conflict that would then be resolved. You need in universe bigots to show bigotry being overcomed.