You won’t be spending any money tonight so you’ll be in the exact same position in the morning, as you are now. Nothing can be done right at this moment, so get some sleep. I bet he’ll sleep fine knowing he’s unburdened himself!
Tomorrow, laptop and paper and pens out and sit down together. Write down ALL of your outgoings from memory - mortgage, phones, kids clubs, grocery shop, TV, if you get a takeaway every weekend.
Tot everything up, then get into your online banking, download a PDF of the last 3 months statements and see where the money is actually going. Compare what you think you’re spending on groceries/takeaways/clothes, to what you’ve actually spend over the past 90 days.
What is DH spending on and how much? Tot it up and look at it in black and white. He has to look at it to take control of it.
Look at debts. Write down what is owed - mortgage, car loan, credit cards.
Get onto YouTube/tiktok/somewhere online and find a basic pdf for a budget. Input all of your bills. Call the bank on Monday and ask for an appt/help from an advisor. Get CC debt onto a 0% card, get realistic payment plans set up. Set up a joint current account with an agreed upon amount needed for groceries, dog food, miscellaneous life things (NOT tech or gadgets or ASOS orders or whatever it is that’s being bought). Weekly/monthly budget comes from there, make it work. Leftover money in your individual accounts to be divided up as needed - if he has CC debt, he needs to create a monthly repayment plan and pay more than the minimums ideally.