I would argue that even if season two's ambitions exceeded it's execution, at least it was trying to do something. Still not a season of Trek that I think deserves any real regard, but it did add something new and interesting to the fabric of Trek. And maybe at some point some comic book or novel will actually do something interesting with that thing, because I can't imagine we're ever actually going to see it revisited on screen.

Season three was exactly the dark, cynical mess that everyone complained season one was because Admiral Clancy cursed at their space dad. Jack Crusher is the infallible, ultra special badass everyone accuses Michael Burnham of being. Season three is ideas I would expect to find in someone's first attempt at writing fanfic, not the work of seasoned television professionals.

And, to be fair, both seasons two and three were made by the same people, so the fact that neither of them were particularly good should not be shocking to anyone.