Husband seems miserable with his life and family

My husband used to be a recovery support specialist which is someone who is in recovery for either substance abuse or mental health issues and helps support clients. He has been sober from heroin for 8 years so his job was to help support other people through drug addiction. He's also in recovery from trauma. He loved his job but they ended up having to let a lot of people go for money reasons. Support specialist were the first to go because they don't have degrees. So he fell into deep depression after losing his job. Because he had an extremely traumatic childhood he went the bed until he was 19. Whenever he gets too stressed out that starts back up. So he was stressed which caused him to start wetting our bed. Then wetting the bed added to his stress so it was just a cycle. We have 2 young kids and I work part time. We ended up having to take out my husband's 401k to keep from getting evicted for not paying rent. My husband found a job 2 months ago at the Amazon warehouse and I thought things would get better after he started working but it's gotten worse! Our kids are asking if daddy still loves them because he doesn't play or hug them anymore. He hates working for Amazon. He looks miserable from the moment he wakes up and when he gets back. I'll see his truck in the parking lot and he will get home and sit in the car. His car horn was going off because he slammed his his head to the steering wheel. He has to wake up earlier to go to work because we have to shower and strip the bed because his bedwetting hasn't gotten any better. We don't have sex anymore. We haven't had sex in 6 weeks so that's making me feel unloved and unwanted. I don't feel loved by my husband. He's miserable. And it's making us all sad. He seems to just hate his life and I feel completely unloved and the kids are confused. When he comes home he just goes straight to the bathroom and stays there for hours.