For crying out loud, @Anonymous881, please don't feel you have to justify yourself to batshit men people posting on your thread.
Even if you were off your face, screaming the lyrics to "Never Gonna Give You Up" with one tit out of your dress, and had crawled all the pubs looking for him, there is still no excuse for his behaviour! A sane & reasonable man would introduce you both as his wife & SIL - with anything from humour to, yes, embarrassment - and steer you gently to a pint of water/some food/a taxi/home, depending on the circumstances. In short, he would look after you, his wife.
He literally rejected you and his role in your life. To your face, with witnesses.
He told you to fuck off. In the context, there's no way this could be taken as a joke or banter.
You've said that, in any case, you weren't misbehaving. I believe you.
There's nothing reasonable about what happened. It's stark. I feel so bad for you, and I also feel bad that you're even questioning this. Someone's really done a number on your self worth 😢Everyone deserves better than this - everyone! No matter what he says now, his position was made clear in that devastating five minutes.
@WeeblesWobbled, your story made me feel like crying, too. Neither 'husband' was worthy of the title.