Honestly of it keeps people out of hospitals, that’s good enough for me. Overwhelming the healthcare system seems like the worst case scenario.
It doesn't. Consider a household with less than five members (index case + less than four others). "One in four" means that less than one additional household member will get infected on average, i.e. herd immunity at the household level is achievable. Whether that translates into herd immunity at the population level is a different question that requires information about transmission between households.
No that's not how it works. The virus is endemic now so it's not a one time event. Eventually another household member will get infected and bring it back in.