Rotary bits can handle soft to medium soil formations. But when you find yourself between a rock and a hard place, you need specialized equipment designed to power through rock formations.
If you have perforated casing and the formation no longer produces enough, you must seal the open perforation with cement before you drill down to the next aquifer.