I didn't say LTB. Wouldn't dream of it. I had a drinking problem that became alcoholism and my DH stood by me. Eventually I got sober.
Your DH is probably not an alcoholic. Not yet, anyway. But pissing the bed when you're drunk is nowhere near normal social drinking. He has a problem.
I'd suggest he starts setting a limit on his drinking. So many drinks and then no more. That should stop the bed wetting.
However he may not be able to set a limit on his drinking and keep to it. In that case he's already definitely got a problem.
I know someone whose DP said he was no longer prepared to tolerate her heavy drinking and how it affected her. They were in their early 20s.
15 years later she is so, so grateful to her DP. She's quite sure that if he hadn't given her that ultimatum she'd have gone on to have a serious problem. She says if she's honest about it she was already lying about her drinking and suffering bad effects - like cringing in shame at how she'd let herself down the night before.
I tell this story to make the point that if your DH takes action to limit his drinking he can avoid developing the misery of a full blown drink problem - which I wouldn't wish on anyone.
From what you say, it's time for him to try to limit his drinking. If he can't then you both have your answer. It's vital that he's honest with you about how much he's drinking. If he lies about it that's another red flag. All alcoholics lie.