Alot depends on the age - last visit, my (then) 2y dd was scared in the Little Mermaid show - my 4y dd was okay. This year, my 3y dd did not like Gaston in the Beauty and the Beast show... my 4y dd was okay. Our visit was 4 months ago and just last week my 3y dd was talking about how Gaston was scary and mean and she didn't like him....
bottom line, depends on the kid and exposure.... my kids aren't movie watchers, so aren't really exposed to the 'scary' element in all the Disney stories (Nemo's mom dying, Snow White's mean witch, Cinderella's mean stepmom/sisters, Lion King dad dying...)