From what you report it seems that your husband has indeed taken his unemployment as the end of life. It seems that he needs some professional help. Talk to him patiently explaining that all this is not only unhealthy for both of you, but also for your child who is growing up. Suggest to him about taking the help of a counsellor to deal with the situation. Your suggestion of seeking the help jointly might help him feel supported. If he is reluctant to take help, then you can visit the counselor alone first and later give him a feedback as to how you felt. This might motivate him to accompany you the next time.