What happens with lead acid batteries is that over time and particularly in warmer climates the positive plates corrode (the negative ones do not) and when they corrode they get bigger, this can put pressure on the insulating separators and push through to cause a short. When this happens the shorted cell voltage drops from 2 volts to to zero, so you then have only 5 cells in series at around 2 volts each and only 10 volts at the terminals.
The other common failure mode after long service is when one of the inter-cell welded connections breaks, in this case there is now no continuity of connection in the battery and although you may see some voltage at the terminals with no load, as soon as you try to draw any current from the battery the terminal voltage drops to zero because of the broken / high resistance joint.
I am of the opinion that after 4 to 5 years (depending upon initial quality and alloy mix of the battery plates) any lead acid automotive battery is firmly in the 'living on borrowed time' category, and either of the above faults can happen at any time, the battery with a shorted cell may still start your car, but the one with the broken connection will leave you stranded. Even a good quality battery that is replaced after 5 years will still have only cost you about 30 pence a week.
Low mileage also kills batteries, because if they are kept below about 50% charge level for any length of time they normally 'sulphate up' and a white coating appears on the plates and drastically reduces battery efficiency, and in most cases it is irreversible.