I've never seen anyone wasted at WDW, I guess I'm just lucky. I don't mind drinking or being around people who are drinking, but the hot sun and the jerky rides would seem like a bad combination with a few cocktails. Not my idea of a good time.
As for the guy who peed on the tram: That's why they tell you to wait behind the yellow line.