The central pickle the writers had is they wanted to create repeated existential crises to the Federation even though it kind of stretched plausibility given it was only ten years prior to TOS and the events within were never mentioned.
I mean, Season 1:
This was really hard to square away with the existing timeline for obvious reasons. Of course, some of the same criticisms could have been made of Enterprise, since it introduced a flawed "hero" who singlehandedly saved Earth from a risk we never heard anything about before. However, at least that was a relatively distant prequel, not a prequel immediately prior to TOS.
- Confirmed Michael Burnham was one of the most infamous (and heroic) people in Starfleet history.
- Introduced the most technologically-advanced ship in Starfleet which played an instrumental role in the Klingon War.
- Showed that the Klingons brought the Federation to its knees and were within minutes of bombarding/invading Earth.
- Gave us a technology (the Spore Drive) which can travel anywhere in the entire universe instantaneously, Not only that, it can also travel to alternate universes, and travel through time.
I think Season 2 handled things much better overall. While there was ultimately a struggle which threatened "the entire galaxy" this was always happening enough on the DL that as far as the Federation as a whole was concerned, nothing much of consequence happened. Though the elaboration of the relationship between Michael and Spock was a bit concerning, insofar as if the two of them reconciled it would have to be asked what happened to Michael that she was later on never a part of Spock's life.
But really, I think Kurtzman & company simply want to do something similar to the Klingon War/Control every single season. They want a big epic battle where the entire fate of the galaxy stands in the balance and it's up to the Hero Ship to save the day. You just can't tell these kinds of stories at that point in the timeline without people asking questions. Which is why Strange New Worlds - which appears to start in the timeline immediately after Discovery Season 2 - is apparently going to be more small-bore episodic stories. The problem wasn't the point in the timeline, it was the kind of story they wanted to tell didn't belong as a prequel.
It’s a shame the production team don’t come on here isn’t it. I mean I (and others) basically laid that all out for them just after the show was announced. It only took millions of dollars and two seasons to find out why Enterprise had enough problems nearly twenty years ago

Still, we now have so much Trek that eventually they will land on something ok again.