I have tried (not for myself) to get social housing.
It essentially is a lottery, there's a low chance of winning, but you hit the jackpot when you do.
I think it has a lot of negative effects, one guy when I was there said his daughter (single mother, natch) had been waiting for a house for a number of years; apparently she wasn't priority because she was living with him.
Basically you get in a shitty situation, they give you a house, which is all right and proper in caring society, but then you are set for the rest of your life, no matter how your circumstances change. And then your children in turn see that you are paying £400 PCM for a house instead of £1000, and think 'hmm, does work really pay?'. The answer, unless you are a banker or a barrister or something is 'No, not really'. So they put their name down for a house too. And they are told when doing so 'Sorry you are not in the highest priority group, you have to be a homeless single mother for that'.
So basically the state rewards destructive behaviour that fucks up successive generations with 'free' houses (they aren't free, but with Right to Buy meaning a large windfall (not sure how true this is anymore), below market rate rents, secure tenure pretty much for life, a maintenance/refurbishment programme, and Housing Benefit covering the rent in most cases initially, even if not, as in the OP's case, years later, when they would no longer qualify for social housing but are still bed blocking).
Anyone who thinks council housing isn't heavily subsidised is utterly deluded. Clearly if it wasn't, there would be no demand for it, but in fact it's rationed and restricted in most areas to only the most desperate cases. Hell, we've just opened the borders to 19 million Romanians, many of whom will make their way to the UK and will need housing; a Romanian shop has just opened directly opposite one of the local Polish shops, so clearly it's happening.
Excluding the uninhabitable highlands of Scotland and such places the country is grossly overpopulated and housing naturally extremely expensive.
I pay £1550 PCM for a 4-bed rented house, which is very cheap for private, and I can't keep a pet (we'd love a dog), we could get turfed out at any time - only plan in 12 month cycles, and to buy a family house around here costs £500k+.
I've never contemplated social housing, frankly, because I'm middle class and I like to live in a middle class area. Crime and disorder is associated with social housing - we have friends who live in a council house, very nice in a village in Bucks, backing onto fields, except that the council moved a family of Pakistani drug dealers in next door, who smashed their car when they complained about them parking on their drive. Because of this association, and the fact that the country's worst schools serve areas of social housing, it's much easier to fit in in certain areas of social housing if you are an antisocial scumbag, than a middle class parent who tries to raise 'respectable' children.
The effect of this is that social housing is further ghettoized in many areas, with some people desperate to avoid the problems and pay the £££ extra for private housing, others who have no choice/money getting drawn into the antisocial web of disorder, and a third group, who just don't give a shit, forming a hardcore of social housing cases - the government is obliged to clothe, feed, and provide them with shelter, no matter how poor their behaviour. Again, the state rewards and reinforces destructive behaviour and creates an apartheid between social and private housing.