It's a tough fantasy to have, because it could go either way.
For me it never came, my dad neither admitted he even had a drinking problem, or that many of his actions, and those subsequent consequences where as a result of his drinking.
The heartbreaking irony was he was in hospital and dying
as a result of his drinking, that's how far the blindness can go.
For me though I needed to detach my own life from his life, addiction is addiction, and if an apology came then great, but if it didn't well at least I knew i did what I could do, and in the end it's ultimately the addict's responsibility to change, it's not for anyone else to take the burden on, and definilty not a son or daughter to take responsibility for a parent's behaviour and try to change them.
We have to somehow manage to move on should the worst happen, and realise addiction can be a very selfish thing, even on someone's death bed unfortunately!!