Waterworld bombed because it was so expensive to make. Plenty of people went to see it, just not anywhere near enough people to cover its costs. A SyFy original series based on Waterworld would have a much smaller budget than the movie did, so it would have a much easier time being profitable.