You'd still have to compare it to the equivalent usage of the same energy into a LiOn battery, and in many cases it wouldn't fare well.

Maybe there's a future world in which we can do it all in orbit -- harvest comets, produce hydrogen in space using solar power or nuclear, and efficiently drop it down to earth in some safe way. That would definitely alter the equation. But by the time we figure that out, it'll probably be too late.