The Scripture passage makes no reference to the guests being drunk so there’s no more reason to assume they were drunk than to assume that the 5,000 that Jesus fed were gluttons.
In fact, the verse seems to suggest that no one was drunk since the waiters express surprise that the “good wine” was already being served. It appears to be nothing more than an embarrassing situation for a newly married couple (not having enough wine on hand for the guests).
It is also important to remember that wine in the ancient world was often mixed with water and wasn’t as high in alcohol content as today’s wine.
