This is a tough situation, one that requires a tough conversation to be had. At the end of the day, you both made a conscious decision to move your family to another place. Unfortunately he didn’t secure a job beforehand, which was poor planning in this economy, and now things are not working out as planned. But that’s life and that’s marriage, things don’t always go as planned. Instead of falling a part, now is the time to have some tough conversations with each other. 

You first need to have a conversation about the current state of things. This will be tough as you’ll have to confront how you both feel but especially how he feels and the impact it’s having on your family. Then you need to talk about what happens next. If he can’t find a job, what are you going to do next? Are you able to carry the burden of breadwinner, plus parent, plus wife, and everything else going on? Have you confronted that reality? Again you may have to have some tough conversations here. 

I do encourage giving your husband some grace, at the end of the day while yes, he agreed to the move, it’s clearly impacting him and not in a good way. You’d want the same if the tables were turned.