Well... if he's turned up on the doorstep with a suitcase saying he can't do this any more, and she didn't feel able to turn him away... she's most unlikely to come anywhere near this thread for a little while, for at least two and probably three reasons (embarrassment, busyness, not wanting him to find the thread).
If you do read this, Solost, just remember everyone here is on your side. We might believe it would be better if you did things differently, but in the end you're the one who's got to live with the consequences of your actions and if you want that man back, nobody has the right to tell you you mustn't.
The only thing I will say is that it doesn't sound as if he's in the right mindset at this point to actually come back properly and make it stick. So if he plays silly-buggers for a while, leaving and coming back, texting BB in the middle of the night etc, not many people would be all that surprised. If you want help through it, we'll still be here and I can guarantee the majority, at least, won't judge you. (We might judge him, no promises there; depends whether he treats you precisely as he ought.)
Meanwhile, hope you're well and happy and best wishes to your lovely DCs.