You'll be back where you started and maybe worse if he starts again.
That's how it works when alcoholics try to moderate.
It's like the disease keeps progressing even if they are dry for awhile.
It did for me.
There is no such thing as a "reboot" once your body chemistry has changed
to accommodate addiction.
Sounds to me like he will drink whether you endorse it or not, but most likely try to hide it if you say no.
I think you'd better get Plan B in order and let him know you meant what you said about no room in your family's life for living with addiction.
Please note that if he sneaks it, your children may be at risk if he drives them
or looks after them. I don't have kids, but many times I didn't reveal I was drinking to my spouse or hid the amount.
That's a very common strategy (unfortunately) and dangerous if you are looking after children.