The entire symbiont concept in DS9 was a very thinly veiled metaphor for transgenderism. There even was an episode where Dax falls in love with another woman. Trek did that a lot - they took real-world issues and made them about aliens in space, with the underlying message being, “What if we took this thing that seems strange or threatening to people and viewed it through the lens of sci-fi entertainment?"
Really, what Discovery did wrong was that they forgot to make it entertaining. Trek has always been woke.
Yep, however I'll expand on the last point.
It's not that Trek isn't "woke" (or whatever word bigots use for "something I don't like" in the future) it's that Discovery tried to draw too much attention to it. Trek was always about presenting a world where being different or having a disability didn't matter, not that it didn't exist. TOS was aired in the 1960s where some states still acted like Jim Crow was the law, there was a black woman on the bridge of a military starship, out ranking two of the male crew on the bridge and everyone just acted like she belonged there.
I've been meaning to go back and watch the later seasons of Discovery but haven't really felt compelled to. I think they might have jumped the shark in S1. The older series (TNG, DS9, VOY, ENT) were slow burners, they didn't really get going until the 3rd seasons. The alternate universe thing in the latter half of S1 might have gotten too exciting too quick.
I also watched the first few eps of SNW on a plane and felt it was way too dark... I mean literally not dramatically, the sets were far too dark to see what was happening. Surely by the 23rd century we could make reliable lighting.