Stay Strong!
You deserve more, and he will try to get around this any way he can now that the consequence is actually happening.
Think of it this way--letting him stay will set both of you up for more of the same, and if he doesn't face his consequences, in a very real way you are "enabling" him to continue drinking.
Put yourself first for once and realize he will benefit too, if he chooses to really seek recovery.
I agree with Hopeful, guys at work is just him trying to manipulate you. You know the truth.
And no, I don't think a church group once a week is nearly enough given what you've shared.
Best to you