Renters didn't used to be cursed: social housing offered millions of people a steady, safe and secure home for an affordable price.