Rubella was endemic for years, but is now eliminated in most counties. With vaccines endemic is a step to elimination in some cases.
But those are very different viruses to SARS-CoV-2. Even if we could achieve 100% vaccination coverage, it’s likely that the virus would still circulate because our immunity is not 100% effective at preventing infection and shedding.