How much time are you spending focusing on what he is doing or not doing? I do think his focus needs to be on his sobriety for a while, and your focus needs to be on you and making yourself happy regardless of what he is doing (the same as when he was drinking). It sounds like you are making some very positive steps in trying to find a new job, and thats wonderful. Do you really need him to be happy about it for you to be happy about it? I think perhaps there are some lingering codependent behaviors at play.
Echoing what Babyblue said, hopefully his behavior is part of a growing process, and he will even out eventually and be able to reconnect with you and your family. You definitely have some legitimate needs that are not getting met. But he may not be able to meet them. You will have to decide whether you want to live with it or not if he can't. I would give it more time, refocus on you and making yourself happy whether he is connected or not.