|MLA Citation:||Bloomfield, Louis A. "Question 1542: Why do deep wells require pumps at the bottom?"|
How Everything Works 22 Jul 2018. 22 Jul 2018 <http://howeverythingworks.org/print1.php?QNum=1542>.
So far, so good. But if you make that straw longer, you'll need to suck harder. That's because as the column of water gets taller, it gets heavier. It needs a more severe pressure imbalance to push it upward and support it. By the time the straw and water column get to be about 40 feet tall, you'll need to suck every bit of air out from inside the straw because the pressure imbalance needed to support a 40-foot column of water is approximately one atmosphere of pressure. If the straw is taller than 40 feet, you're simply out of luck. Even if you remove all the air from within the straw, the atmospheric pressure of the water below the straw won't be able to push the water up the straw higher than about 40 feet.
To get the water to rise higher in the straw, you'll need to install a pump at the bottom. The pump increases the water pressure there to more than 1 atmosphere, so that there is a bigger pressure imbalance available and therefore the possibility of supporting a taller column of water.
OK, so returning to your question: once a well is more than about 40 feet deep, getting the water to the surface requires a pump at the bottom. That pump can boost the water pressure well above atmospheric and thereby push the water to the surface despite the great height and weight of the water column. Suction surface pumps are really only practical for water that's a few feet below the surface; after that, deep pressure pumps are a much better idea.