Fans have been waiting for years for the 2002 hit horror film to hit streaming platforms