You're asking a few different questions here, that may be deserving of different answers.
-Not all fuels are automotive fuels. There are renewable fuels that aren't suitable for cars but that could be used for home heating or for use in power plants.
-There are renewable fuels that aren't alcohols. Most of these are still young technologies that aren't commercially viable on a large scale yet, though bio-diesel is doing fairly well.
-Alcohol fuels aren't an awful idea. Those include methanol, propanol, etc. But they aren't compatible with modern cars (not without modification, that is), and there are also concerns about toxicity in case of spills or leaks (methanol is much more toxic than ethanol).
-Ethanol fuels are somewhat convenient because they're basically compatible with modern cars. But from an energy standpoint, they aren't very good - it's extremely difficult to refine ethanol to fuel-grade purity. Until recently it took more energy to produce a gallon of ethanol fuel than was actually available in the fuel - I think we can break even now, but that's it.
-Ethanol from corn is fairly awful, and exists mostly because of politics. It makes little sense, for a variety of reasons, and I hope we see a shift away from it in the US within the next few years.