The Neverending Story has elements of sadness, like when characters face difficult challenges or part ways. But it also has hope and adventure mixed in.
I think it's not that scary. The story has more elements of wonder and imagination than outright terror. However, if you're easily frightened by certain types of fantasy scenarios, you might feel it's scary.