Not every show appeals to every Trek fan.

Just as Enterprise didn't appeal to me, so Academy won't to others. But if the show goes on long enough it may attract those trekkers who find appeal in a semi-angsty drama among a college age cast in a progressive academic setting.

I am confident that their are overseas bot accounts intervening to magnify cultural and political conflicts in entertainment spaces.

MAGA is an American thing, but there are plenty of people sharing their dumb opinions outside of the US.

Also, MAGA nutters aren't actually less intelligent than anyone else, just cowardly and resentful. They don't want to think about what's causing the problems in the world, because then they might have to reconsider parts of their worldview and that's scary. So they want someone to just swoop in and fix the problems without fundamentally changing anything, or failing that, gives them the feeling they have permission from society to lash out against anything they consider "abnormal" and is therefore a potential cause of the problems. And so they'll resent anyone who criticises them for that or tries to undermine that feeling of societal permission they want or already have.

But not wanting to think about certain things is not the same as being unable to, and any intellectual capacity not spent on actually thinking about real problems and how to solve them can then be spent on how to create the impression that their opinion is dominant and therefore they're not doing anything wrong.

Anyway, the point is that while there are definitely legitimate criticisms to be had about the newer Star Trek shows, your metric isn't very useful for demonstrating that. To begin with, why hide behind numbers at all? It just makes it look like you're trying convince people that your criticisms carry more weight because the world agrees with you.

How’s that? If 10 of your coworkers rated your job performance as 5/10; would you think that’s not a critical indicator of a failing performance?

No. I’ve never been evaluated in such a fashion, and I’d resent it if I were. I think my boss should have the competence to judge my work on its own merits. I judge the shows I watch the same way.

I’m confused as to your purpose here. You seem to be arguing that the show is bad because it’s unpopular. Is that how you form all your opinions? Popular vote, no need to think for yourself?

It could be a terrible indicator of your actual performance, if five of your coworkers rated you a ten honestly, but the other five rated you a zero because they hated the Black Lives Matter sign in your cubicle.