That would only be true if we could test everyone before they re-emerge out of their burrow. We know that a substantial percentage of people infected are asymptomatic and while they are less likely to transmit the disease, with prolonged contact as it happens within a househould, they can. The median incubation period is 5 days and the 97% range is 11.5 days. So with a 2 week quarantine, unless you lock everyone in a separate room, you may have an infection chain within a household unit and come out with a carrier at the tail end.
As mentioned above, we don't need zero new infections. We need a number of new cases and a R0 that is low enough that the methods of tracing and contact isolation become sufficient to eventually eliminate the bug from a population.
As for it 'becoming seasonal', as these epizoonotic viruses go, its not all that likely. This isn't the first one. They tend to come, run their course and disappear. There may be another round of this 5 years from now when there is another jump of a virus from bat or pangolin to humans, but that wouldn't be the same SARS-cov2 but rather SARS-covX etc.
