A councillor believes a car park will be “left to rot” for years after it was revealed it will cost millions to reopen amid a lengthy process to find a developer to transform the site.