I probably would have done the same. It is so hard suddenly cutting yourself off emotionally when you see someone you love in distress. I could not say "well [censored] to be you" and walk away. But probably should.
I don't know what your H was like before all this self reflection, and I am far from an MLC expert, but from what I have read, self-reflection is not one of the traits of an MLC'r in the throes of the middle of their crises. If anything, it would probably hit somewhere in the later stages. Others here probably know more and can give better advice on how to react to one who has hit depression.
PS - mine looks like he is in replay and is going to be stuck there for a very long time ... with some anger thrown in just to keep me on my toes.
The talk was also him testing the waters, reconfirming you are still there for him if he needs someone to talk to. Plan B stuff.
I would push for a revision of your child care proposal. You have to have a childcare schedule. Can you stay at your sisters a couple of nights a week. He cannot continue being a part time dad who only gets the good bits.