Once again, it depends on your kids. Most of it is harmless fun, but there are a couple of parts that could raise your eyebrows.
I don't do horror AT ALL, and was terrified by the ghost in the refrigerator, and I was in high school when it came out! It scares me *even now* to watch that part. Having said that, I don't think I'd have a problem with my kids (11 and 13) watching it. After all, they would be watching a DVD at home where they could leave the room or FF, which is what I did with the fridge scene last time I saw it - lol. When I first saw it, I was in the theater where there was no escape!
I'm not sure I would let a 6 year old see it, but then my DD11 was scared of the evil queen in Snow White when she was that age. She would always leave the room when those parts came on. (older DD loved Snow White and was never afraid of any parts of it). You'll have to be the judge if it would be too scary for your 6 year old or if he/she would simply find it amusing.
A warning: Be prepared for them to get the theme song stuck in their heads!LOL!