The challenge (other than just building the darn thing) is whether or not the current flow is sufficient to keep the brine levels down around the intake port.
I have no idea how practical that idea really is (he's pretty enthused of course) but I liked the notion of using the pressure difference between the ocean surface and at depths to do the reverse osmosis work for you.
[1] http://hawaiideepseawater.com/source [2] http://oceanvodka.com/our-vodka/ingredients/
Let's say we take the amount of water mentioned in a link in another comment, and desalinate 54 million cubic feet of clean water per day in a single plant. That is 204 400 cubic meters per day. It is a huge amount, but we're talking about operating this plant at depth of 1 km. 204 400 cubic meters is 0.0002 cubic kilometers. The California Current flows at around 0.25 m/s which means that the cubic kilometer of water around the desalination plant will be completely exchanged almost once per hour, 21.6 times in a day.
I would say that the salt that you take from desalinated water is an entirely insignificant problem when just left in the ocean, even locally. It's a drop in the ocean. Most likely the saltiness of water will vary a lot more due to other reasons (e.g. how much water evaporates locally).
Other aspects of access to more water in places like California are probably a much more relevant environmental problem. That water is mostly going to be used as irrigation water in agriculture. This will flush a huge amount of earth particles to the ocean. Literally, it will eventually wash away the agricultural land, unless it is used sparingly. When doing that, it puts additional earth material in streams and rivers.
And then there are the issues of fertilizers, pesticides etc for the ever increased volume of agricultural production.
For an effectively unlimited amount of energy. We do not yet live in a post-scarcity era when it comes to energy so that "unlimited" is quite hypothetical. In the same sense that there is unlimited amounts of space available for humans, <please insert spaceship here>.