You have enough to deal with, so focus on yourself and your marriage. It does sound like a big drunken, drug-fuelled mess, but if you want to work on saving your marriage, then that’s your decision.
The trouble with confessions is that while they unburden the confessor, the problem is dumped on the other person to deal with – and how do you do that? Of course you’re going to find it hard though. In your case the positives are these: he was honest with you about what happened straight away and he’s reassured you that he’s not gay or bisexual (just a drunken fool).
You obviously need to set some boundaries now – number one is that you don’t want him going on any more stag dos because you can’t trust him in that environment, and he shouldn’t mind about that.