I'm not familiar with that area, but considering it's not coastal it seems hard to believe the water is simply wasted once it goes into the ground in the lower Colorado basin.
My guess is that most of what sinks into the ground from agriculture makes its way to a saline aquifer. Some of it may end up in the Salton Sea, which itself is very saline and also shrinking.