Because from a literary and media standpoint, utopias are boring. The Federation has never been a utopia. It is a post scarcity society with utopian ideals, but with plenty of flaws to balance out those ideals. In the TOS era, those flaws included penal colonies, the death penalty, albeit for only one crime, contacting Talos IV and lots of infighting among member worlds.
Without conflict, there is no drama. Star Trek has long found conflict in pitting the Federation against less high-minded adversaries, the Klingons and Romulans, the Borg, the Cardassians and the Dominion, the Kazon, etc. That is fine but after 60 years it is also sort of played out.
To your point about Discovery, it’s first season took place before the Federation’s ideals were fully codified in policy - general order 1 had yet to become “the prime directive” for example.
TNG trek took place later and was closer to the utopian ideal. But still wasn’t perfect. The Federation tried to force Data to undergo study as a guinea pig and tried to take his daughter from him for the same reason, they supported unaligned worlds against internal dissent and left untold numbers of Federation citizens to the mercy of the Cardassians in the interest of keeping the peace.
During the Dominion War, the Federation was fine with setting aside it’s ideals as a matter of survival.
During the burn, the federation no longer had the resources to support it’s high ideals so it shrank and degenerated. Now. It is on the ascendant again, able to right past wrongs.
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.
Eh, TNG had a rough start too, but became awesome. Note that it took two plus seasons to become consistently good.
Academy has lots of rough spots, especially in the writing, but it is not irredeemable. It just needs time to find its tone and audience.
Or it simply could be that I haven’t needed to concern myself with the order of operations more than a dozen times since high school. Even when working as a web coder it was so seldom necessary that I can’t recall a single example.
The US education system was still pretty decent when I was in middle and high school in the 1980s, so we definitely covered this in algebra.