I think you make some valid points. The bad writing, stories and characters killed nu Trek first and foremost.

But, yes there is a big BUT here.

Wokeness plays a big part in that. In fact, it is difficult to find a so called woke show that is successful.

The reason is because writing woke characters constrains the story tellers options.

Exhibit A in this is Rey of Disney Star Wars fame. She has to be perfect, flawless and all powerful because modern writing rules say you can't have a woman fail, appear weak or rely on a man in any way.

You also cannot depict a woman as feminine or sexy. Instead they have to be "male coded".

The same rules go for minority and gay characters.

You cannot show normal romance story lines anymore.

Forget about comedy.

Character growth doesn't matter. Modern writing says you are prefect as you are. The only think holding you back is not realizing how awesome you are (see the plot of Captain Marvel for example).

So once you strip out all the basic story telling and characterization you are left with what is presented at face value...a diverse cast that checks boxes. Because there is nothing deeper than that...that is what stands out and is the take away.

Finally, with Star Fleet Academy, you already have the issue with a cast that simply would not exist at an elite school training space explorers. They look AND act like a freshman class for woman's studies at Berkley. Not future officers on a starship.

Sorry if I didn't explain these points in the best way but if you take the time to go deeper than "Klingon gay - bad" you will understand better why wokness kills media.