The smaller pipe has less water in it, but the surface area the vacuum can act on is also smaller so the column of water equals out the same as with the larger pipe.

At sea level, that's about 30 feet deep. If you want to bring water up from deeper, you have to move the pump down the well and push the water up the pipe instead of trying to suck water up like the pipe's a straw.