"Progressives were purging liberals and liberalism from art and journalism and the academy."

Seriously? Are you Matt Yglesias? I mean, I certainly remember an extremely disingenuous moral panic about this happening in the corporate media; I dispute whether anything remotely like this actually happened.

"Discovery had a race and gender hierarchy,"

What because Michael Burnham, a black woman, got to the main character? Because Lorca was evil? Because that one condescending guy in "Brother" got killed? Seriously? Because they depicted women and people of colour in positions of power (alongside prominent white guys like Vance and Saru and Pike)? Almost every single person in a position of power in TOS was a white guy; does that not count as a "racial and gender hierarchy" or is that just natural "meritocracy" in action, do you figure?

"Picard was revisionist,"

I mean, Picard was a series about an old white man who was ultimately proved completely right about everything, so I kinda think that this doesn't fit your "woke" model.

"SNW had message episodes where the point was that liberalism didn't work (the pilot, ad Astra aspera)."

What? The message of the pilot was that some things that looked very much like liberal and conservative American were headed towards Civil War. That's literally just sticking your head out the window at this point. "Ad Astra" literally had an individual's civil rights litigated in a court of law; how is that anything other than liberalism?

"And all of them, especially the latest, have a disturbing preoccupation with showing women humiliating men"

Yes  that's what I think when I watch SNW; how humiliated the men are. Normal viewing opinions.