On a ship that functioned for 105 years, in one of the most hostile environments imaginable; yet fell apart exactly at the time our 'heroes' appear on the scene...

(Not to mention the 'child' is really spry for being 105.)
^^^
Oh, and the whole 'reason for the Burn' was just a telegraphed trope. Starfleet of the 31st-32nd century can't find a ship sending a signal for 105 years? And a psychic child crying over the loss of his mother brought down Galactic society because he projected his grief from the surface of a Dilithium planet?
And Starfleet needs Dilithium badly (as does everyone else in the Galaxy; even though from TOS through the TNG era, there were plenty of races that achieved FTL/Warp technology via other methods - yet by the 32nd century, Dilithium is it?
So yeah, sorry but Discovery S3 was a contrived, tropish,, telegraphed mess.
Now Discovery S4 had some real interesting concepts, and one of the best "First Contact" scenarios in Star Trek. I wish they had devoted one more episode to that First Contact. Because honestly, the pacing was poor. It seemed they had the start and end locked and then struggled to fill in the story. But I will say u Discovery S4 was decent.
S3 (IMO), nope. (YMMV)