Why do so many people give in to addiction- but can succeed (at first) in every other part of their life? I do not know. It took something very radical for me to stop drinking. A classic rock bottom - with a dash of steroids and hell added.
I adapted to- and learnt from a dysfunctional childhood (no blame, just fact) by isolating, hiding- running away. Then as an adult - those maladaptive emotional strategies came into play added with alcohol. So the cycle continued. It was not until I stopped dinking and worked very. very hard to relearn some semblance of emotional maturity that I began to succeed. This means much more than just sobriety. It is working with a counsellor- to work out how to learn, grow and adapt adult coping skills. AA and SMART- are everyday supports to maintain sobriety. There is no magic cure.
Prayers to you.