Family are just not qualified to handle and solve the problems of someone who struggles with addiction. Your husband is getting the help he needs and that's great! He has a long path ahead of him. I don't think anyone here can tell you whether or not he will be capable of a mature, loving relationship at some point in the future.
Please take good care of yourself! You get to decide now what is best for you.