I think if I were you I would consider counselling to help you work though what it is you want.
At the moment you sound as if you want an amicable split and to be able to move on for the future but not as a couple.
Which is absolutely fine by the way.
In my situation, we split, he is still an alchoholic as far as I am aware although we have not had contact for many years. He has no contact with dd.
The thing is, every situation is different, your dp could be an alchoholic but retain regular and good contact with the dc with his parents support.
I'm glad he has been to aa but thats only one visit, alchoholism is a long haul if you want to recover.
If he were to recover he would not be able to drink again, so no, your dp couldn't be "that man".
Can I ask why its so important to you to still be able to drink? I feel that if you were truly committed to your partners recovery as part of a couple you would have no issue with this. Its not really a huge ask.
I'm not critiscising you at all by the way, I'm just asking you to explore your own thougts on the future.
A life with no alchohol is not less of a life, it is just a lifestyle choice if you see what I mean. I think it rather telling that you feel unable to make that lifestyle choice for your dp even though it would be a relatively small change.