Mainly because it was extremely creepy, and the subject of ghosts is usually a big hit with audiences. In addition, it had a nice twist at the end, and it starred Bruce Willis, who is usually a big box office draw.
I don't think the story is predictable. One of the reasons for which this movie was a big hit is that Bruce Willis starred in it and it's also interesting because it has an interesting plot.