um, Davos is pretty clearly going to lead the Night's Watch.

Stannis just has nothing left. He has no family, no army and no one will ever follow him again. You don't fall like that in any story and have redemption, especially when he was never a central focus to begin with. Like, literally no one ever believed he was more than a distraction in the real power struggle in Westors. He was barely above Balon Greyjoy and Varys in the game.