I don't think a character or characters have to die, but if at the end of the day, all of this running around for clues to open a treasure that gets destroyed in 5 minutes and only leads us back to a place where the Breen go home and the Discovery crew just go back to Starfleet HQ, what exactly would be the point of all this?This seems like a deliberate middle finger to Discovery. Other Treks could have that ending with the ship warping off having restored the status quo (TMP, TUC, mostly). Discovery is treated different again.
What did we learn about these characters that we didn't know before?
In TMP, the entire mission is about accentuating characters trying to find purpose while dealing with V'GER. Kirk pushing to get the Enterprise back to reclaim purpose after being behind a desk, Spock trying (and failing) to purge out emotion in order to be more Vulcan, Decker finding an opportunity to be something more with what's left of the woman he loves.
In TUC, the entire story is about letting go of biases and the past. "The Undiscovered Country" of the title is the future, and the main throughline of the story is Kirk going from someone that calls the Klingons "animals" and saying "let them die" to the person who realizes the value of peace.
Neither one of those movies re-establishes a status-quo. Who those characters are at the beginning are fundamentally different from who they are at the end. That's the reason why I hope it's not a ho-hum ending. If the people involved in this show have a vision for it, and want to make a statement, I hope they go bold with it and they use the opportunity to say whatever else they want to say about this series and characters.