I think you are just trying to sooth your own conscience here by focusing on your husband.
I notice you changed your story a bit.
Originally, you said
”He hadn’t been drinking as far as I know. That’s the thing, I can’t even really ask him as he’s just like what; you were the idiot which I can’t argue with!”
Perhaps he had had a drink, perhaps he was at work early the next day, who knows?? You don’t know because you haven’t even had a proper conversation with him about it.
I’m still getting over the fact that you went out with work colleagues (you said you are professionals? So I’m guessing some sort of professional role with responsibility?) and got so completely shitfaced (red wine on an empty stomach, not spiked) that you lost motor control, couldn’t speak and were vomiting. By 9pm!!!
We’ve all got shitfaced, but this is next level. I don’t think there would be many people that would do this in a professional setting. And I don’t think it is holier than thou to say so.
The next morning you should have been out of there as early as you could manage, apologising profusely and if the colleague’s husband “Insisted” you should have “insisted “ back that you were quite capable of getting yourself home now, thank you. You are a grown woman, not a child, you have agency.
That is entirely on you, making a sober choice to put them out further the next day.