> If we could just create hot and cold piles or underground wells or something that we could tap into 4 months later when the temperature has changed, you would have completely solved heating and cooling.

This is literally what ground-loop heatpumps are doing. The ground loop is used as an energy source in winter, and since water is always at 0C, the heat pump efficiency can always be around 500%. And vice versa in summer.