Should I be afraid of getting COVID again?

The 12+ million people in the US, and 60 million worldwide, who have been infected with COVID-19 — and survived — are likely asking themselves the same questions: am I immune now? Is it over or do I have to brace myself for the possibility of a reinfection? Moreover, could the second time potentially be worse than the first?