When I was drinking I had a similar pattern to your husband in that I would sometimes go a few days without and sometimes only a day.
I was also moody most of the time whether I was drinking or not.
Now that I no longer drink I have found that most of the moodiness has gone away and in that area I guess I would classify myself as normal. I still get mad or sad when there is something truly worthy of making me feel those emotions.
This is just my experience but you may not see any improvement in that area unless he tries to quit completely.