My little guy LOVES it. He's seen in several times - at ages 2, 3, and 4. He's never been scared by it.
I will say, though, that he doesn't get scared by much. He loves the Haunted Mansion, doesn't mind the bad guys in movies, etc. His favorite movie is also the original Fantasia, so he loves seeing Sorcerer Mickey on stage!