A vaccine is unlikely to wipe out the virus for good. They just aren't that effective. We can't wipe out other coronaviruses or the common cold by vaccination even if we wanted to.

It will continue to circulate in the population, just in a less explosive manner. This also means it is possible we will never reach herd immunity in some absolute sense much like we haven't for other coronaviruses.