Right.
You know now what you are married to.
And it's not good. It's not good at all, and as PEOPLE DON'T CHANGE, it is always very probably going to be NOT GOOD.
He does not respect you. He does not have your back. He thinks of himself first, and what he wants to do, even if it's bad news for your family, your children's security, because he thinks he is MORE IMPORTANT and the big man, and your role is to be meek and mild and 'support him' ie sit there like a lemon and accept anything he wants to do with his life, even if it affects you negatively.
You don't have an opinion, you don't have equality, he does not have to consider you, you have no rights to have your views heard in your own family.
YOU NEED TO LEAVE.
Right now. Not necessarily permanently, but right now, if you EVER want to have a cat in hell's chance of being respected in your own family and having any agency in your own life, you need to draw a boundary right here and walk out.
How fucking DARE he do what he has done and then tell YOU it's over because 'you don't support him' - WTF? This is 100% clear. He has no respect for you at all. Stay and you are choosing to be his doormat.
'Too fucking RIGHT I am not supporting you. I am not a doormat with no agency in my own home. We are either a team, and we make decisions TOGETHER, or too fucking right it is over. We are done. If you want to think this through, think how YOU would feel if I made a massive decision like this that would utterly affect your life and told you to put up and shut up. It's NOT OK, it's NEVER going to be ok for you to act like this. We're over - thanks to YOU. We were over the minute you thought 'No, this is MY decision and not a family one. I am never going to 'support' you in acting like an arrogant prick who thinks he gets to make all family decisions alone. You don't.'
Financially you will absolutely be better off without him right now. He's resigned: no benefits. You will be able to claim as a single parent and get help. How are you with family - are they far, could you stay with them? As you say, it will also bring home to him exactly what it is that you do. Because that comment 'Who brings home the money' says it all. That's where twats like this are coming from. They see the wage packet and think 'I'm doing it all'. They aren't... because without the other part of the team life would look very different. Let him sit in shit realising that there's going to be no dinner unless he not only cooks, but shops in advance. That actually having a child isn't all about coming in from work and having a play and bathtime, but it means planning your time around caring for them, day in day out, when you have other stuff needing doing. Etc., etc., etc.
I cannot tell you how strongly I urge you to do this. If you stay, I honestly think you are done: your life will be very much what you don't want, it won't change and the chances are you will split anyway, unless you really do train yourself into the 1950s. So make the break now and have a vague chance of pulling this arsehole into line.