Let me just give a bit of back story...
Both DH and I went to private schools. DH went to a big name boarding school and hated it, left without any real good qualifications as he mucked about. I went to a small day school and was happy and left with good enough grades to get me into the local university. I am an only child. DH has a brother and a sister who have both done very well for themselves and so now send their children to private schools too. DS is therefore the only one of his generation in the family not to go to a private school.
We sent him to the local comprehensive school that looked like a very good option when he was in primary, but over the years has slid. It's now having extra support due to failures in certain fields.
DS worked very hard throughout school and ended up with good a levels that got him into the university he wanted to go too. He was never particularly happy and often was ribbed for being geeky and a bit posh.
Could we have afforded private school? Probably, at a big push without any holidays that he's enjoyed but we both have pretty average incomes. (Less than 100k together)
DS has admitted he feels like he massively missed out on not being sent to a private school. About 50% of his university went to private schools and he feels they are cliquey against people who went to state schools. He said well if his grandparents afforded for his parents to go to private school, why could his parents not do the same?