I can only relate my own experiences. I used to have a high rate of battery turnover, particularly on vehicles with limited use and normally shortly after the warranty had expired. Some years ago I invested in a C-Tek (XS 3600) charger and now charge every battery, regardless of use, at least once a month. This includes regular used diesels, low use collectables, scooters and restored garden tractors. Some batteries indicate fully charged within the hour, some take overnight but since I have done this, I have hardly lost any batteries. Matter of fact, the battery on my 2004 W203 c220cdi, lasted 14 years and on the 2009 W204 c220cdi, 10 years. Both were original MB gel type batteries. Since their replacements were three times the cost of an ordinary Exide, I opted for the latter as neither the cars nor I, will likely be around in another 14 years!
Modern cars and their batteries behave strangely. Driving the W204 on a motorway I suddenly received all sorts of warning messages. Stopping and restarting did not help and the auto gear lever then refused to unlock from Park. Fortunately, I remembered that there is a release button under the gear lever cover and I was off in limp mode. After leaving the motorway I went over a bump and the car was back to normal, no warning messages. A dealer suggested a loose earth but long story short, I replaced the battery and no more messages since. Incidentally, this battery at the time measured 7.8 Volts and the car still started normal, without any hesitation.
Quote from another site: A very wise old service manager I worked with one time told me; "Batteries are like people, they are all going to die sometime. Some last a long time and some die young. Some will drop dead just like that".
I expect a brisk trade in vehicle batteries after this lock down.