It will leak through the casing (eventually) contaminating drinking reservoirs. This has already happened in many old wells that were drilled before the rules that forced them to plug.
How can oil, not under pressure, contaminate water that is near the surface? Again is the oil under pressure or not? Oil wells are hundreds if not thousands of feet deep. Are you saying the well fills up with water? The casing fail? Is that the problem?