Your own link puts the EROI of renewables in the same range as conventional oil (wind slightly better, PV slightly worse), and way better than shale or sand oil.
And of course you can make liquid fuels by cracking water and then doing chemistry to add carbon (which can be from atmospheric CO2). This is what Musk has planned for Mars, the process is from 1897: https://en.m.wikipedia.org/wiki/Sabatier_reaction
Further chemistry can turn that into long chain hydrocarbons, from what I remember of school.
And of course you can make liquid fuels by cracking water and then doing chemistry to add carbon (which can be from atmospheric CO2). This is what Musk has planned for Mars, the process is from 1897: https://en.m.wikipedia.org/wiki/Sabatier_reaction
Further chemistry can turn that into long chain hydrocarbons, from what I remember of school.