I personally think it's pretty stupid and inconsiderate to be anything more than a little tipsy at an attraction like a theme park. I don't like being around anyone under the influence and so do a great deal of people. Even a lot of people who enjoy drinking don't like being around those that are drunk when they aren't themselves... and since most people at a theme park won't be, it's just inconsiderate.
I'd rather have smokers, personally, than obnoxious, loud, smelly drunk people who are likely going to try and talk to me and be stupid.