Where do farms get some of their water in rainy years and most of
their water during a drought?

the old alchemists made significant contributions to science even though there starting premises were off a bit. their conclusions after failure would steer them into better directions for investigation. science is no more than close observation and the initial mistakes result in rethinking and retrying experiments.