When, is a good question. Most predictions say <50 years based on what we know about existing sources.

Most cars can probably be modified to run on alcohol so classics will probably still be around.