Sorting between transparent objects is done based on the z-coordinate of the object's center in world space. The sort offset that you apply modifies this z-coordinate. In your case, it looks like as if the water plane is always below everything, so you should give it some high positive sort offset to push it back into the sorted list.