As a kid growing up in an alcoholic home, I'd say no to the last part at least.
Growing up in that kind of dysfunction is just incredibly damaging.
It models addiction as a "solution" to pain, unreasonable compromise of needs from the sober partner to the addict,
denial of truth in the family, and that isn't even getting to the part where the addict directly hurts the child emotionally
when drinking either by anger, guilt, or ignoring them.
I'm a recovering alcoholic now, and I have intimacy issues due to being raised like that so I'm not the success story you are looking for,
unfortunately, but the number of posts you've been reading should be telling you the odds are certainly not in your kid's favor.
I know this is really really hard to hear, and I hope your partner chooses recovery instead of forcing you to a very difficult choice.