I have rented privately and now I live in a housing association property. I have also lived in a council property [when there was more of a distinction between council/HA-now many councils housing stock is managed by HAs]
I have had people moan at me about my having a social housing property while they are in private rentals, but all of them were at some point in the same situation I was when I got my first council tenancy, just they didn't want to lower themselves to the depths I had to, eg, living in a horrible hostel for a time and having little choice over where I ended up and living in flats on estates that most people wouldn't walk through if you paid them. They also had access to the funds to get into private rental, which at that time I didn't. They chose private rental.
I know the criteria is much narrower now and I can understand people feeling pissed that they can't get on a housing list.
I am very lucky in that now, after years of living in some real dumps, I live in a nice house on a nice road, which you wouldn't know is a social housing property unless I told you.
I can understand people being envious of that, but it wasn't easy by any means to get to this point.
If I rented my house privately, it would cost around £1000 per month more than what I pay. Private rents being so high is the real issue [as well as not enough social housing]
Also IME, lots of people think that social housing = free. Many seem to think only people on benefits live in social housing, which is of course not true at all.