Sometimes I wonder if people who want Star Trek to be non-controversial and non-political do so because the progressive social commentary, which has always been there, sometimes challenges their own world views. And instead of examining their own worldviews, which makes them uncomfortable, they instead choose to dismiss the source of their discomfort as being "woke" or "preachy".
True story. I was raised in a very Evangelical household and was taught to avoid "the gays" at the cost of my soul. Even though TNG and DS9 had done allegorical stories with LGBTQ themes, I always Justified those stories to myself by saying, "well these are alien species, and we can't judge them by human standards".
It was a Star Trek comic, of all things, that got me to question my worldview on the subject. One of the main characters of Marvel's Starfleet Academy series (how's that for a full circle moment?) was depicted as being gay. However, it was buried so far in subtext, that my naive younger self never picked up on any of the clues.
Then in one issue, they made all the subtext abundantly clear enough that I finally put things together. A thoroughly disagreeable and unlikable character had figured things out and gone to Captain Sisko complaining about the unholy relationship. And I agreed with him. Every word.
Of course, his complaints were rightly slapped down by Sisko and dismissed as bigotry. Even though I knew in the moment that Sisko was right, I can't even describe to you how enraged this made me in that same moment. However after time to reflect -- and not a brief period -- I realized that I had seen myself in a Star Trek antagonist and didn't like what I saw. That this was no different than any other representation of Star Trek's ideals that I had watched the story and nodded along with. It was the first domino to fall of my previously toxic worldview. I view it as a change for the better.
So, yeah, Star Trek's woke preaching messaging had what I honestly believe to be a positive influence on who I am as a human being. That's what Star Trek does. That's what Star Trek has always done. If it ceases to do that, it will cease to be Star Trek.