You are the provider now and he's the stay at home dad. It's exactly the same as most of us one here, just the gender reversal. Many stay at home moms feel how he feels.
I agree though, most of the 'good' men out there truly want to provide for their families and have a harder time staying home. My husband was laid off and got very depressed from it, and it's not his personality type at all. Just remind him how appreciative you are and work together on coming up with a long term plan so he won't feel lost, as well as doing some budgeting to help you all figure out your finances.
If he can't find work right now that wouldn't offset the cost of daycare, perhaps he can find a night shift somewhere, or even volunteer with the mrc (medical reserve corp), or casa (court appointed special advocates for battered children) or red cross or something... anything to help him get out and still feel valuable on a social level. Plus, the extra networking may help him open doors for employment.
He can get free career counseling through my church. They help all people, regardless of their religion or background and there is no obligation for them to go to the church ever:
some of the resources:
https://www.ldsjobs.org/ers/ct/stakes---wards.jsf?name=jo...
here's a center near you:
https://www.ldsjobs.org/ers/center/find_center.jsf