In the podcast (
http://www.sciencemag.org/cgi/content/full/sci;1162018/DC2) Nocera explains the process perfectly. This "missing link" in electolysis has been the production of O2. Now this is possible. And now a closed loop of water splitting and water production is possible for the first time apparently. So, this could indeed be a possible way to store energy for times when there is no sun or wind available to produce electricity. Nocera also mentions that there are already alternatives for Pt for the hydrogen production and they are going to test them.
However, indeed nothing is said on the efficiency of the whole process and thus the economics of this process. How large a system do you need for a household and what would it cost? Hopefully we will get answers soon.
Still you need photovoltaic cells or windmills to produce electricity for your house, your car, etc. And you need extra electricity to produce H2 and O2 for times when there is no sun or wind. PV cells still cost a lot and still are not efficient enough (thus take up too much space). So, there are still other missing links to solve to really start a electricity revolution.