This recharging of the surface water will have little effect on the aquifer. But it will lessen the clamor for conservation measures perhaps. The long-term answer is still to grow the high water demand crops such as almonds in places (wherever they will grow) with abundant rainfall, such as the southeastern U.S. It would be awfully tough to pump Louisiana dry.
The climate here just will not be able to recharge aquifers with the present level of pumping. Household consumption of water is still a miniscule proportion of the usage, but it gets most of the attention, mostly because of the economics of agriculture in california makes regulation of them basically a taboo, at least so far.