I'm usually not a big fan of endings in which someone marries and lives happily ever after, but for Sansa I really hope this will happen. It's what she wants - a happy relationship with a man who loves her and whom she loves, and I'm fairly sure she wants children as well. I usually hate this kind of ending because it doesn't make any sense for many female characters, but it does make sense for Sansa. I want her to get what she wants. Which is one of my reasons for shipping her with Stannis, because he's enough of what she wants, but in a way she never expected.
Sansa as somewhat lonely mistress of Winterfell who occasionally bangs her bodyguard Sandor (and is probably married to some guy she doesn't love, because Winterfell needs an heir) just makes me incredibly sad. She deserves better.

I agree, Sandor will most likely die. But I'm okay with that, because he's one of those characters who are probably incapable of having any sort of happy ending.