Does a horror movie have to be scary to be good

"The true horror film (I use the abominable description) has its roots in the fairy tale, and the fairy tale has its roots in the soil of humanity....For the audience, this kind of film is a release--a bizarre world outside ordinary experience where the tensions are enjoyable." Boris Karloff