An oil and gas company recently fracked a “shallow” well on my property, just over 200’ horizontally (min by law) from my water well. They drilled to a depth of about 2500’ and fracked in several zones from that depth upward. In this case, less than 1/2 mile down. I still have a great water well (tested). I don’t really care for the eyesore though.
You haven’t filled out your profile, so I have no idea what state you are in. Or country.
By and large, shallow oil is gone. Deep oil is still plentiful.