Star Trek: The Next Generation is the height of what Gene wanted for all of humanity to aspire to be. Being able to look past the fact that someone is this or that, came from this world or that world, or what have you. None of that is in today's Star Trek.
I'm sorry you don't see that in the newer Trek. The truth is, it is because there are people out there that so much want to dictate to others what those others should be that they are unable to see beyond what is portrayed on the screen.
Homosexuality, people of different colors, religions, political leanings, all of it, has been around for millennia. None of it is going away because some people are unable to tolerate it or its portrayal in modern literature.
Love is love however its portrayed, and I think it unfortunate that there are those who are unable to see that on the screen just because its between two people of the same sex.
I have absolutely no issues with bringing in societal issues into play but it must be able to advance the plot. Two absolute great examples of this come from Star Trek: Deep Space Nine episodes titled "Past Tense" (3x11 and 3x12) along with 7x15 "Badda-Bing Badda-Bang".
You picked my least favorite of the Trek series. I don't agree.
I dare you to go back and watch those episodes and then come back and tell me that that wasn't pure genius. Face it, the writing of today's Star Trek is garbage when compared to the absolute genius that was classic Trek.
The way I see it, Anson Mount portrays Captain Pike far better than Shatner portrayed Kirk, and Ethan Peck puts more humanity into Spock than Leonard Nemoy every put into the character. In fact, the original TOS writers never put much at all into the humanity of Spock. It's only in Discovery and, I suspect Strange New Worlds, where Spock is given the deserved character development. Spock is, and always has been, a deeper character, and not much in the way of character development was ever payed to him in TOS.
Truth is, I think that people don't like the newer Trek because they don't want to face the fact that it portrays humanity much more accurately. And these side stories, which recognize that not everyone is like everyone else and that not being normal is an aspect of humanity that often propels it forward.
If you want to call that portrayal "in your face" and "woke for the sake of being woke" so be it. However, I suspect that there are large number of fans out there (given the fact that Paramount+ has repeatedly renewed Discovery) who identify with it and feel as if "people like me" are finally being represented on screen. Put yourself in their place. No one is asking you to be what you are not, rather, have some empathy and understand what it is like to not be part of the "normal" crowd where you have to pretend to be something you are not to be acceptable to the "normal" crowd. I suspect that you rarely, if ever, feared for your life because you were different, faced the prospect of incarceration because you were different, being denied jobs if you were different, and so on. And if you call the portrayal of so many different types of people in a fictional series anything but genius, I disagree.
IMO, the way the modern trek stories are woven is pure genius.
No one expects that you should live your life according to fictional stories. They are fiction. Lighten up.
As I said before, no one is forcing you to watch them. If you don't like them, don't watch them. Perhaps you are disappointed that they are not what you would like. That's unfortunate, however, most of us experience entertainment we don't like in our life.
Perhaps what these new series are daring people to be is tolerant. IMO, the world would be a much better place if there were more tolerance of people not like ourselves.