Sorry for the wall of text but I wanted to give a fuller picture, TLDR at the bottom

So my wife F 38 and me M 40 have been married for 12 years now. We've had a fairly great marriage and the especially in the past couple of years have been amazing and we are more in love with each other than we were at the beginning of our relationship.
All our friends (inner and outer circles) adore the both of us and they say that we have the perfect relationship and to some extent I do agree with them.

I went on a bachelor's trip with one of my close friends who is the last of us getting married to Thailand. The other guys in the group were all looking to get laid and get up to some sort of debauchery. I on the other hand was not even trying to hook up or anything of that sort. On the very first day we went to a club and I got really really drunk where multiple girls came up to me (mostly hookers) but I turned them all down. Bunch of the guys left with girls and about six of us were still at the club.

By this time I get really really hammered. We decide to head back to the hotel and once we reach there there are a bunch of girls sitting in the villa. I was up to my drunken antics trying to mess with everyone. One of these girls (hookers) seem to have a banter going with me and my memory is very hazy but one thing led to one another and she told me to prove I could handle her (?) I told her to come to my room to find out. One of my friends handed her the cash handed me a condom and sent us to the room. The whole thing happened so fast... My memory is hazy and don't know how I could do something like that, I am absolutely appalled with this, this is so out of character for me.

Once we entered the room she goes in for a shower and I had about 10 minutes to reflect on what the fuck was going on ...the moment she came out naked, I snapped back to my senses (I remember this clearly). I immediately asked her to leave and I don't want any of this so I paid her (second time apparently) and she left.

I couldn't deal with the guilt of what I had almost done the next day and I broke down crying. Once I came back home, I could not bear to look my wife in the eye and I confessed everything. She is really really upset and broken right now but appreciates the fact that I was upfront with her and honestly told her everything but she says that her image of me is now broken and she needs time to get over this if at all. I honestly now feel like a bigger idiot for actually telling her, especially since nothing actually happened.

My wife is just speechless and numb since the past 2 days. We are never this awkward around each other so I am at a loss for what I should say.

What the hell do I do now?

Tldr: In a very happy 12 year relationship with my wife. Almost hooked up with a hooker in Thailand while drunk out of my head but did not go through with it. Felt extremely guilty about it and confessed to my wife now things are extremely awkward. How can I make things better?