Welcome, and I'm sorry for your situation. I think that 'functioning alcoholic' is, at best, a phase one passes through. It's impossible for alcoholics to control their drinking as I'm sure you understand. At this point, it sounds like you want to make a decision. Staying together is somewhat appealing because you've been married for a long time, but staying together means continuing to live in chaos. It's also important to consider what's best for your daughters, if they are living at home.
It might be an idea for you to talk to a lawyer, just to learn what your options are. If you think his job is in jeopardy, talking to a lawyer could be helpful. You are very welcome to continue to post here, but we also have a forum for Friends & Families:
https://www.soberrecovery.com/forums...ly-alcoholics/