The waste product is brine. It's an extremely salty sludge that's toxic to marine life. In the same way that fresh water is "just" diluted seawater, but pumping millions of gallons of it into a coastal ecosystem would wipe it out.

The pipe should really go a dozen miles out to sea and then get pump-mixed with the destination water