A well uses a shared water table. The water that soaks into the earth replenishes both your well and others near you.
But that’s just nit-picking. You’re perfectly right that the vast majority of rain water collection is either just borrowing the water for a short time or replacing tap water, and it would be very hard for individual users to negatively affect the system in any way.
