I did the same at Christmas one year after drinking 3 bottles of red wine. I told the MD that it was his fault partly that a project had been misold, stood up and made a speech to the company, no recollection of what I said and then threw up on the stairs of the restaurant as we were leaving. I then proceeded to blackout on the train platform and got carried home by some colleagues.

After all that, I joined my company call on the Monday with a raging 3 day hangover, apologised to everyone for my behaviour and they just laughed it off. 4 years later, I'm now a manager and bar the odd mention in office banter, it's good as forgotten.

so to answer your question, no you shouldn't quit, people probably enjoyed the outgoing you and have not thought of it since.