Yes, it can be scary depending on the child. It's dark, loud, you get wet, and there's villians and fireworks.
When my younger DD was 1, she slept through it, 2 she cried through it, and at 3 and 4 she enjoyed it but still needed her ears covered and didn't like getting wet so we had her wear a coat.