Of course it takes more energy to make the fuel than you can get out of it, that's so basic it's not worth mentioning. The real value in this system is energy storage as hydrocarbons, which we already have infrastructure in place for, and are hard to beat energy density wise.