I would guess the environmentalists would be against it saying that it would lower the sea level. Though that would help since they predict many areas to be under water soon.
If I run water from my tap, the thought of it deriving from seawater is certainly more palatable than sewage. But maybe others think differently.