On a family car, it'll be too much sitting on the drive AND short runs that barely scratch the surface of putting enough charge back in.
For a "collector" like Swotty, or a used car dealer, the answer is to charge or condition regularly, and maybe even trickle charge. Walk into any big private collection, and you'll see CTEK's and connectors hanging around to keep batteries topped up.
For the family car / garden ornament, the answer is to just charge it up if you've left a car pretty much unused for a month or two. It sounds like a faff but it's better than being caught out by a flat battery and better than just throwing batteries away every four years.
I'm "lucky" in that I do 12,000 a year across my three cars these days, so it's less of an issue for me, but I do consciously switch cars so that one doesn't get left unused for more than three weeks. Not just for the battery, but just to keep the whole car "limbered up:" from oils to tyres etc etc.
Yes, I hear you. After covid I bought a trickle charger and plug the Merc in now and again. It will often sit for five days without moving. This gets compounded by me unlocking and locking several times to get things out - that hits the batteyr each and every time. And then, if it only has two or three short trips on a weekend, that's even worse for the battery. It can follow that pattern for a month or two before I find and excuse to leave London for some reason or other.