Keep in mind that the Israeli data is 100% Pfizer's vaccine. There isn't any similar good data for Moderna or J&J. The big question will be if the boosted vaccine wanes at the same rate. If it does, there is no chance to get a high percentage of people to get a COVID shot every 6 months. Yearly, you might get close to the uptake as the flu shot but a much higher percentage of people get moderate side effects to the mRNA COVID vaccines that they don't want to experience.
My mom, who is at least as afraid of COVID as the most fearful in this thread and probably more (which is saying something) had such a bad reaction to both dose #2 and the booster of Pfizer that she said she will never get that shot again.
Your final statement is certainly correct. COVID will be around at some, not insignificant, level for a very long time. Likely the rest of our lives. Hopefully between vaccinations and treatments it can be kept mostly at bay but it's never going away.
Data I've seen suggests JNJ is less effective to begin with, and over time. Moderna doesn't wane to the same degree as Pfizer.
I do believe we will need an annual booster during "Covid season." Not every six months, but every year.
You bring up a valid point about the side effects -- The booster knocked me out of service for 24 hours. And that might certainly discourage uptake.