Who said it has to be scary? Only little kids are afraid.
Horror movies are usually watched to get an adrenaline rush, to immerse oneself in a frightening atmosphere. And I won't even mention the fact that everyone, except those with mental disorders, is susceptible to fear.