LF asked Sansa in s7: “What about happy? Why aren’t you happy? What do you want that you do not have?” We can argue that it was greater power she seeked, a more powerful title than the Lady of Winterfell?
But in s8, Tyrion didn’t understand why Sansa’s upset now that she has a more powerful title, and Sansa gave him the answer: she doesn’t want Jon to leave her.
In the series finale, we seer her as the Queen in the North, the highest title she’s ever had. Is this even a bittersweet ending for her, when she showed season after season that it’s not the power she’s after? When all she’s ever wanted is to be like the maidens in the songs, with a man who loves her so much, with many children who look like her siblings? When she realizes in the books: “no one will ever marry me for love”?
Take away the glorious music from the scene, and I think it’s just bitter. Duty is indeed the death of love.