Many pensioners across the country looking for a comfortable retirement do not have enough money to support this, data shows