Ah, I'm pleased to hear it @ReadyforthechorusLTB . Whilst it's not much of a consolation, I'm telling you what I pretty much can see as the events of the evening/transactions and have no reason to lie to you.
He's then confirmed this when you've questioned him, so I would genuinely chalk this up to him being stupid and reckless for one evening. Not to say he's getting off for spending that amount of family money, but I promise you, if he'd had a few drinks before he went in, then uttered the words "I've never been in here before" he didn't stand much of a chance.
I'm not excusing him as a poor little man who had no control of his own actions. But more that he wasn't a weak little sap, you'd have to be damn strong willed to not get talked into something by a big hitter. Rabbit in headlights would be an understatement. And he was drunk. From the minute the scout on the street approached him, it's all a very smooth sales transaction by a very experienced team, from door to bar staff to dancer.
A lot of women think their partner would never, ever, ever go for a dance. And that's why they blame it all on the man who has done, his choice, he did it all. Sober, perhaps this is more true. But I can't stress enough if they are clouded with alcohol, I can tell you 99% of these men who would "never ever" have a dance, a big hitter will have in the dance room in under ten minutes. You have no idea. Last place I worked I was the second highest earner. Top girl would clear £3k minimum a week. And worked 3 nights a week. She isn't clearing £150k+ a year because she's vapidly flashing her boobs.
I think if he understands how unacceptable this is to you, so he is under no illusion what would happen should he ever do so again, you can work through this.