Underwater was an Alien replacement that struggled at the box office but delivered one of the decade's best sci-fi endings.