What bugs me about discovery is that they ruin the efforts of all of my favorite characters in all of my favorite series by wrecking the federation.
Tolkien decided to not write a sequel to lotr because the happy endings were too well earned, even if mankinds nature is to become complacent with 'good', it's frustrating to restart the struggle.
I agree with your sentiment, but I wish they would have done it differently. In my head cannon, I accept later seasons of discovery as one possible future, but hopefully not the prime timeline.
It was closer to decimated than fragile... And that makes me sad was all.
The amount of culture and history that is lost is on par with what could happen if we don't get our act together in the real world.
Trek has underlying optimism most of the time but there wasn't enough of that to redeem discovery for me. You bring up good points and highlight a silver lining. It's just thinner that the one I wanted.
I think I could have accepted it with a better setup, too. Some unavoidable disaster that made sense, but the 'burn' was flimsy.