Every kid is different. My 13 year old won't go near it still, my 12 year old loves it, and most of my younger kids just have no interest after hearing how my oldest hates it. My 10 year old has nightmares about it from 2 years ago! I can't explain why they feel this way, they have watched Scooby Doo, we do not watch ghoulish movies though.
My oldest loves roller coasters but just doesn't like ghoulish stuff at all. It's odd, but it's no problem for me...if we decide to do it with a few of the kids we just use rider swap so both my wife and I get to ride it with those that want to.
So you never know how your kid will react until you try it. It's goofy, but some find it scary.