Husband won’t look for Job - attraction gone now, want divorce ?

Husband of 6 years was fired over 8 months ago. He won’t put his resume together. Naps and drinks beer all day. He wasn’t like this when we first met and keeps making promises to look for a job. He squandered 70k in savings and surprises me with us not having any money left..I’m at my wits end. After all the burden I’m carrying now I’m to the point that I’m ready to divorce him, and have let him know for months. It makes me so mad and I’ve lost my attraction to him. Is that normal ? He’s a good guy but had shit for romodel parents. His 65 year old mom works 60 hours a week while his dad squanders all their money, ruins credit.. poor woman doesn’t have a backbone so she won’t leave him..theyre alcoholics.. all traits I’m starting to see in my husband. Is there any looking up from here? Am I overreacting? Most importantly will I be attracted to him again if he does get his crap together at some point ? He won’t commit to counseling either... Anyone able to relate or been through something similar?