Hm... tough call. But like others have said, only you know what your child can handle. And if he does your local haunts without blinking maybe he'd be fine with these.
However, if you take him and he's NOT fine with the houses... are you willing to fork over that kind of money just to do the scare paths and more comical shows like Bill & Ted? Or have enough family / friends there to tag team sitting outside Houses with him? (that's what we did on our second
HHN)
The first time we went we talked my DD11 into going. She really didn't want to go, but we really did, so we showed her the map and how we could avoid most of the scary stuff if we wanted to by walking around scare zone paths and not going into houses. So that's what we did that first visit... we didn't see a single House. She only had to walk through one scare path and did pretty good (the actors in the warped Wizard of Oz were kind)... She LOVED the shows - particularly Bill & Ted - that's the only thing that got her to go again the next year...
However, our second visit last year they didn't have much in the way of a safe connection of paths to avoid scare zones. But she realized they were pretty tame relative to the houses, and actually enjoyed a few of them. But Bill & Ted's show last October was lame (mostly due to a dismal year in movies).
As for drunken and disorderly... he'll definitely be exposed to that, but the security staff is amazingly fast at attending to those disturbances, so it could be a positive experience to see that sort of cause and effect.
I think if you feel he's ready, he will probably do fine - especially since you already know kind of what to expect. I find even the actors in the houses are pretty tame with their jumping out and then retreating to their scare spots. Your biggest irritation might be the looks you get from people who think you're tormenting a child too young to be there. I saw a few people my daughter's age, but I can't recall seeing more than one or two younger.
Hope that was helpful
Also, I only recall MIB and Simpsons being open - I'm sure there were a couple others.