Well, don't really have to include politics or whichever "Side" someone is on.
So questions, was it canceled because the new management wants to take it a different direction, or start of fresh? Quite possible. If it was doing gang busters, they probably would leave it alone, it floundering in ratings? Yeah. quite possible.
Ratings in general, from what is "known" it isnt really knocking any boots off in that regard. some places say 2 million watchers, which is less than SNW. If it had a more positive viewer score, like if it was well regarded, but the numbers don't quite get there then maybe, but it has been panned by alot of people.
Also.
You can not like a show, and not be a "Red hat" or "Woke" or stuff like that.
I honestly gave it a try, watched all episodes. It was better than what the naysayers have said, but it wasn't that good either, maybe 4-5 episodes were good rest were Meh to Oh crap thats bad.
For me the writing was just sub standard, I've seen some takes like "there just writing what they know" or the old writers were more subtle, or any of dozens of things.
But it comes down to numbers. If it was a good show, with compelling characters and good writing. People would have shown up to watch it. We all like good TV.
For me it wasn't the Klingon in a skirt, or vomiting glitter, it was just.. What the hell is going on? Why do ALL the characters have parent problems, why does the Admiral's daughter HAVE to be captain? It was just a mess.