It is a common thing for many to think they can moderate their drinking, and might be able to do so for a short time, but it will escalate back into the full blown alcoholic drinking again in no time.
Only he can do the right thing to stay clean and get his act together with a sobriety plan, and it sounds like the two of you have had it with his alcoholism. Moving on to give yourselves some peace in your own lives likely will be the best plan of action if this keeps up.