I was the straight partner in this situation (I posted details of a support group for your husband near the start of the thread).
Our DC were 6.5 and 9 when ex came out to me, 7 and 10 when we separated and 9 and 12 when ex finally moved out. Ignoring the sexuality element for a moment, I was also terrified that I wouldn't be able to survive financially. I did. You jut have to. I managed to get a new job, went full time, arranged childcare. It's not been easy but better than staying together in misery.
The two years we were separated but still living under one roof were horrific from my perspective. It was torture for me. He could have gone sooner, but I had to do all the work of sorting the divorce and getting him to leave. I thought at the beginning of it all that we would be able to stay friends. After all, he didn't choose to be gay and I loved him. But the not leaving was so cruel. It destroyed our relationship and I can just about be civil for the DC but I lost all respect and affection for him. However, I can see how that would be the case in similar circumstances, whatever the reason for the separation.
Back to the sexual orientation factor. Your husband probably still loves you. He's probably still attracted to you. You do not feel the same way about him. It's going to take him longer to get over this. One of the big differences (compared to a straight couple) with a separation where one person realises they are actually gay is that the straight person not only loses the future they had imagined, but also loses their shared history. They question what, if anything, was real about their relationship. Did they ever know their partner? They realise that the gay partner never felt the same way about the straight partner. They simply can't have if they were never into wo/men in the first place. They also feel a lot of confusion about their own attractiveness - can I only attract a gay wo/man? Would a straight wo/man like me? What does that say about me? They feel stupid. How stupid must I be to have married someone and not have realised they're gay? They nearly always experience some form of depression. Insomnia is very common. They feel deeply betrayed. Your husband is very probably going through all this, and that won't be helping his decision making.
If you really want to change your situation, then get yourselves into counselling or get mediation. Talk about how it's going to work, whether you stay together or not. But in my experience, based on the stories of lots of straight partners, staying 'together' is likely to lead to lots of resentment on both sides. Sooner or later, you will probably meet someone and that changes everything.
You know how people on here talk about 'the script' used by cheating men? It's the same in this situation. It generally plays out in much the same way, with some variation. And it nearly always starts with 'we still care about each other very much, want to stay friends and we co-parent brilliantly, so we want to try staying together'. Sadly, it almost always ends in tears.
I appreciate that this is very difficult for you. But it is exceptionally cruel to want to keep your husband in a 'relationship' that has no chance of ever being mutually satisfying because you are scared of change. It's not fair on you either, but I'm biased towards the straight partner because that was me and it is shit.