I do not think this will happen. Getting most households to be self-sufficient is probably not as cost effective as centralized grid. One there's the economy of scale. Second, any peaks and troughs will generally be balanced out between households and the overall buffer (aka reserve) needed could be lower.