He needs to stop drinking. To stop drinking he needs to accept he has a problem. Accepting he has a problem requires a massive change in his thinking.
But what? The DUI hasn't done it. Visits to AA haven't done it. The psychologist isn't doing it. Jesus -- what's it going to take? Do you want to be around for the precipitating event that finally convinces him he needs to stop? No.
And in the meantime, newsflash: waking up in a pool of urine is not acceptable. It's not how people live.
.