The chemistry and ways in which Lead Acid batteries decline is explained by Wikepedia. One issue is that leaving them to discharge slowly forms insoluble Lead Sulphate, reducing the amount of charge the battery can hold, and how much current it can deliver.
Car batteries last because they’re operated well within their comfort zone. A a short heavy current is drawn every time the car starts, followed by a fairly aggressive recharge as the car is driven along – takes about 20 minutes. The cycle discourages sulphation. Conversely, leaving a car standing slowly kills the battery.
Leisure batteries have a different internal construction. They are less vulnerable to sulphating, but still do it.
Batt Aid type chemicals, might remove enough insoluble sulphate to gee up the battery, but it’s a gamble. The improvement is temporary and the battery does not fully recover fully. Worth a try, but keep expectations low! Whether or not the trick works has never been proven. If the battery is too far gone, the treatment won’t work at all. Confusingly, any improvement is short lived – the battery seems better for a while, but charge is reduced, and it soon declines. Unfortunately, people tend to report initial success, but not how long the fix lasted. Murky!
Another might work dodge is to discharge the battery quickly enough to expand the plates inside by rapid heating, enough to dislodge the Sulphate, which falls to the bottom of the cell. Not enough to dislodge the wanted filler or cause other damage. A suitable resistance is needed, something that will draw a 100A for a few seconds without catching fire! I leave it to the reader to spot reasons why this one is best avoided.
Battery recovery is on the border between solid science and mumbo-jumbo hearsay. For example, if the battery was over-charged, causing the water to electrolyse into Hydrogen and Oxygen, then it really is good to top up with distilled water, and to check the acid concentration with a Hygrometer. In ye olden days, this was essential maintenance because vehicle voltage regulators were clunky inaccurate electromechanical devices that allowed a fair bit of overcharging before switching off. Electronics have long since fixed that, so now it’s rarely necessary to add water and acid. Difficult even to buy battery acid. Conversely, if battery is on the way out, the door is open to folk remedies, with mixed results of dubious value. The evidence isn’t encouraging,
If the battery life is usefully extended by several months, the treatment was worth it, otherwise the money would have been better put towards a new battery! In my youth, my car wouldn’t start one cold morning, but I topped the battery up, applied the tablets and recharged it. Got me through the winter, then I had to replace it. At the time, I thought that was a win. Now, I wouldn’t take the risk: I want my car to start reliably and am happy to pay for it.
Dave