Waterworld had a massive budget and so when it didnt make profit in its initial theatrical run, critics deemed it to be a failure. It has a massive following if you go to any physical media or movie forum. From what I read, the film eventually did turn a profit when factoring rentals, TV airings, DVD sales, etc.