But for all of that, liquid hydrocarbons offer among the best weight/volume energy storage capacity available to us. The alternatives: EVs, LNG, hydrogen, compressed air, flywheels, etc., just don't hack it. For an efficiency perspective, the next best bet is human-powered vehicles, but these aren't an option for all people. Transit and dense infrastructures are your next best bet.
While I see us moving from fossil fuel, I still see liquid fuels playing an important role in mechanized transit (ground, water, air) for as long as we're technologically capable of doing so.