Fewer than one in three believe the current pension system works well for them, with lower earners, the self-employed and women the least likely to feel positive.