I am an 8 in a half year old girl, but I loved this very very very very very much. But I'm not so sure about the little kids.
It is kind of scary, and at the end the "goo" of the pumpkins sucks down to another garden which causes a carrot version of the pumpkins. And I found out the the "goo" actually came from aliens, which is not really "goo", but alien poop.
My 2 year old son is a complete boy-boy, but for some reason this scares the daylights outta him! We have it on DVR and while he normally loves action in shows and movies he will freak out before it gets past the opening scene.