People love to mythologize. The truth is usually much more mundane. Columbus in particular has a combination of Mr. Magoo quality and nastiness that is will lead history to forcefully forget him in short order.
In short order after 500 years? You're not wrong about his qualities but he was still the guy who did it first, and it's still called the Columbian exchange.
When I was young Columbus was lionized in schools. Now young people I talk to demonize him more and more. He wasn't even first (Viking explorers beat him there by a lot), he was just first to brutally exploit. I'm sure the things that are named after him will be renamed eventually to honor more deserving figures.
That is a very US-ian perspective. AFAIK he is still lionized in Latin America, and likely will continue to be, as he is a sorta-kinda the ur-founder of all those nations.
That may be true, but if so it will be a failure of education, and a tragedy of identity politics (was that gleeful rapist who was so loathsome even his own people sent him back to Europe in chains, really the best icon anyone could find to rally around?)