You make a lot of sense.
It sounds, to me, like you want a working partner to help make your ideas a successful reality, and he wants someone to provide him with a respectable title and drinking money.
And it also sounds like you are experiencing an enlightenment about this.
Enlightenments aren't always easy.
In my experience, until they are so sloppy with so much drink that they really don't give a rat's a**anymore, alcohol addicts are very invested in the picture of themselves they present to the world, though it is usually a facade.
Because, really, drinking is their job. And that ain't a pretty reality.
What do you do?
Decide, I guess, if staying is worth it.
Or if you have, to financial reasons.
I can tell you, though, that, unless your man decides to stop drinking and accepts recovery, this is how it is going to be, but worse as time goes on.