My views on this subject are fairly well documented, but I agree one hundred percent that if the script is rubbish, everything else falls apart. I also believe the worst thing anyone can do is try to preach or consciously bludgeon viewers over the head with a message, however noble it might be. Here are my thoughts on why, if you're interested:

https://medium.com/illumination/be-a-storyteller-not-a-preacher-991a6efecb6f

In the specific case of Star Trek, yes, it has always had "progressive" values, so it is foolish to complain about the programme for that reason. But my giddy aunt, those Discovery episodes have been rather interminable. Far too touchy-feely. I do like Christopher Pike though, so at some point I look forward to catching up with Strange New Worlds.

My love for Star Trek blows hot and cold. I love the original series and crew, and some of the films (especially The Wrath of Khan and The Voyage Home) but I was less sold on the Next Generation and subsequent iterations, though I watched them on and off. Sometimes they could be outstanding (the Borg episodes, for instance), but sometimes it all got a little tedious, especially when Deanna Troi "senses aggression" from aliens shooting photon torpedoes at them, and Picard's response is invariably to hit them with a leaflet campaign.

But I did love the first JJ Abrams Star Trek film. I was also amused by a satirical article I saw in The Onion (I think) which had the headline: "Star Trek fans complain new film is exciting, entertaining, and lacking in heavy-handed messages about tolerance."

One final point: The all-female Ghosbusters wasn't terrible, in my opinion. And I loved The Last Jedi. :)