Can we come back from rock bottom?

My husband is an alcoholic. We have three children. In the past couple of months his drinking has gotten really bad. He’s what I would call a functioning alcoholic. He still goes to work everyday but that’s the extent of it. He will drink when he knows he’s supposed to care for the baby while I do something. He’ll stay up all night drinking on the weekends and sleep all the next day and leave me to deal with everything else. He sees nothing wrong with this behavior and claims he’s not an alcoholic. This past weekend he woke up around 10 after staying up until 4 or later, I woke up at 4 to nurse the baby but went back to sleep. I personally think he was still drunk. He was screaming and calling me names, ended up yelling at the kids for no reason and was just being crazy. I tried to leave and in his attempts to get me to stop he grabbed my ponytail. I called the cops and he was arrested for domestic. We’re not allowed to have any contact for 3 weeks while we wait for court. The first two nights he stayed in a hotel and went to the bar every night. Now he is staying with a friend and working on staying sober. His sister said he took an assessment and they recommended he spend 28 days in rehab. He’s found a rehab and worked out with work to use temporary disability so he can keep his job and still get paid while he’s receiving treatment. He’s supposed to go Monday. I’m really happy for him and I think I’d be willing to work things out if he can get sober and continue therapy and counseling going forward. I know it’ll always be something we deal with. Unfortunately I cannot talk to him about any of it due to the no contact order. Any advice or just stories about coming back from rock bottom?