> they have effectively infinite fresh water from Lake Michigan.

While the total volume of the great lakes is appropriately great, the areal recharge rate is much lower than one might expect. IIRC about half of its recharge is from groundwater, and so competes with aquifer withdrawals elsewhere.

Overuse is still a concern.