Is moonlight sonata by Beethoven a ghost song or something?

well like mostly when a movie that scary or spooky about to come in or an events/part they alway put the song in there lol just wondering