Ok, tried it at ground level off a pond water source. Still doesn't work.
So, just to be clear that I'm not missing a step, all I need to do is lay pipe from the water source, end with a T, place sprinkler on T, place farm plots, and finally plant seed, right?
Edit: Does biome have anything to do with it? The entire map is wasteland biome, FYI.