We love it but TBH with a young 'un we skip to the GW scene described and I try to skip the boat ride. Seriously, beheading a chicken in a children's film is a dark dark choice...
Never had nightmares from this. Now, Tremors and Terminator were another story :)
Still, I've had way more nightmares rooted in real life situations than anything else. When I was 3-4 we had a bulldozer and steam shovel out to replace our septic tank. For YEARS, maybe even into early adulthood, but with less and less frequency I had the dream where the bulldozer was chasing me to the deck and it felt like I was running through quicksand.