Your first guess seems more likely to me than your second. He'll have hit absolute rock bottom and has to fight his own way back. Makes him more of a sympathetic person after the whole Winterfell fiasco (from the standpoint of the viewers). I'd say it's quite likely that in either case he's going to ally up with his sister because she's about the only person he can turn to.