Technology can never overcome the laws of physics and chemistry. Most of the hydrogen discussed in these sources has a source with carbon attached to it. So even if technology can extract said H2 economically, the question of disposing of the carbon (or dioxide) still remains and may become an even bigger lightning rod for criticism in the future. Secondly, as I mentioned, splitting water takes an enormous amount of energy and generating from a renewable source is the only logical solution.
So, as I said in a previous post, there are several aspects to this situation and when you put the entire value chain together (production, distribution, storage, by-product disposal and usage) it doesn't add up to a attractive picture no matter how much advanced technology is developed to solve a production-related problem.