Did the story of red riding hood supposed to be scary?

[Mokats]

Now they are making a movie out of it witch looks scary idk if the original story book was to be scary