An exhibition at the Academy Museum explores the transgressive power of scary movies, channeling our deepest fears about life, death, and the unknown.