Nothing wrong with vaccine hesitancy. Plenty of good reasons to wait or be hesitant about the new vaccine, not the least of all the emergency status by the FDA of all but the pfizer, or the new and experimental nature.
The issue is when people go full on nut case conspiracy and make up shit that a child could easily disprove, for example the common lie about the vaccine having killed thousands of people in the USA, which is not even close to true, or the lie that VARES records deaths from the vaccine directly, which can easily be disproved with just a few moments of research.
Its not their hesitancy to take the vaccine that makes them bat shit crazy, its the bullshit they spew when they try to explain why.
I wouldnt say it doesnt work, but you are right to say it works far less than we had originally hoped due to the rise of variants (it is effective against the original).
If all you do is get the first shot and nothing else you are significantly safer than doing nothing at all, at least according to the current data (we can never rule out some future complication given its new tech, but that seems unlikely at this point).
That said, while its probably still a good idea to get the initial vaccine I do agree that a 3 - 6 month booster will not be practical and overall wont completely solve the problem, even if it does reduce the risks. The only way to solve the problem would be to create a better vaccine that includes the new variants and try to roll it out to herd immunity point very very quickly, which may be impractical if people dont cooperate (and they probably wont if they arent forced, and forcing people has its own issues).
So yea while your concerns are valid, probably still a good idea at a minimum to get an initial vaccination even if you wont be getting the boosters.