Our day to day car is never any trouble, but my wife was ill and didn't drive for many months at a time and I also have a kit-car, so I have have had to deal with numerous, very flat batteries. Modern intelligent chargers do refuse to charge them, but I have saved them by giving them a while on an old, basic charger, before switching them over to the intelligent one.
As an aside, the Aldi/Lidl ones are pretty good, allowing me to leave the charger on permanently to keep the kit-car battery healthy, but they have a nasty little design problem - if we have the RCD trip (too many items with input filters!) or there is a momentary drop-out or someone accidentally knocks the garage power off momentarily, they default to the off-state when power is restored. Weeks later I go into the garage and find a flat battery! I'm sure that they could either retain their state using a small amount of power from the battery or default to charging if they detect a battery when mains power is restored.
SteveW