Little kids can be so empathetic that it freaks them and everyone else out. "Whoa-oa, here she comes" is scary. This woman is going to come eat you. To a five-year-old kid, that's pretty scary. "Riders on the Storm" is a spooky song. I didn't like it when I was little, and even though it's kinda cool now, I don't know if I'll ever like it.
One time when my son was maybe four or five, we were watching Thomas the Tank Engine (these anthropomorphic steam engines and their little adventures) and Thomas get in a wreck. That alone didn't bother my son, everyone bumps into things sometimes. But they had to lift him up with cranes on set him on the track. It was a very tricky situation, and kinda scary. Just watching that scene, my son got so scared that he started crying. Once Thomas was safely back on the tracks, all was well.
Oh yeah, the song. Yeah, kinda goofy. I like some Hall & Oates, but this one's a little too silly.