Yes, a good cry may help. There is nothing you can do for him, this is 100% his problem to resolve. Your husband is an adult, responsible for himself. He will find somewhere to go, they all do.
As for your 8 year old, this child must be your priorty, you are the childs voice, you hold their future in the palm of your hand. Believe me, I know, I lived in a home of two alcoholics, I heard and saw everything and I paid the price, don't do this to your child, a child deserves so much more.
Read others posts, it will help, lots of knowledgable people here, real people who care!