There are times in all our lives when, much as we hate it, for our own long term wellbeing, we have to swallow our pride and do the things we least want to do. And now your husband has apologised to you, do you think you could persuade him to go one step further and go and apologise to his boss and ask for his job back?
Your financial position is obviously such that his pride is not going to pay your bills, and you are already falling behind. Could you persuade him that this might be a short term thing until you can get back on your feet financially, and then he can look elsewhere for another job.
As your husband is the main breadwinner, I think he has to take some responsibility to get you back on track, even though this is increasing the pressure on him..
You've both obviously had a rotten time lately and are suffering from a lot of strain but now is not the time for him to give up. If he can't immediately find another secure job I don't see what other options he has. You can go on relying on families to bail you out indefinitely. And given the current credit crunch, I suspect that new building work in West Yorkshire is going to be rather difficult to find. Meanwhile, could you take in a lodger temporarily to help you pay your bills, or perhaps do some other home -based work like dog walking, ironing, etc.?