I don't think we'll get rid of it. It looks like we'll be able to turn it into something manageable like flu. In time, as our immunity builds, there's a fair chance we'll be thinking of it as another entry in that list of viruses that are dangerous to some people (like flu or RSV) but which the rest of us can cope with.
We'll see better vaccines, maybe some that can help build sterilising immunity (so the vaxxed can't infect other people) - but we could be waiting years for those. Better to assume that we'll find a way to live with it, rather than viewing it we're fecked for the indefinite future.
I'd love to think "live with it" will mean better mitigations - better tests, better sick pay if infected, better ventilation indoors, better treatments if infected etc - but that may just be wishful thinking, as it requires political action.