This is why I only credit TOS in the context of what it was in the '60s and only like TNG/DS9/VOY up to a certain point. And I was never a fan of ENT to begin with.I would say that Star Trek in general is conservative (as with much US media) - it's not really depicted the consequences of its possible socialist future, and of course has for most of its history been a majority white, American, hierarchical, masculine, heterosexual, sometimes militaristic, rarely heterodox vision of the future. It's very popular with conservative as well as progressive people, because it is chimerical - while it shows what remains arguably a conservative world, it preaches - in a limited fashion - something which rhymes with more progressive values (if you wish to hear it) - but rarely shows it.
DSC and PIC are the only two Star Trek series I've gone in all the way for, unapologetically, and without qualifiers.