It's probably been said, but the pressure on special schools is as much down to them being pared right down, 15 years or so ago, rather than anything else.
Anyhow, I have 2 boys with SN.
Oldest is now in year 8. He has ASD and ADHD, strong PDA traits. not articulate, but has a huge vocabulary and is very intelligent. He can not cope with people full stop. Local lovely and very supportive MS primary was hell for him. Too many people. Local special schools really, truly honestly weren't a good fit, as the only way they could meet his needs was by involving partner mainstream schools, which would have doubled his stress levels over what they already were. In year 5, moved him to an indie specialist school for (now) SEM/ASD without even having o go through tribunal (so rare for that school!)
DS2, now in year 6, has ASD and was non-verbal until a few years ago and presents as having severe learning difficulties. With 1:1, he has thrived in the local school. No, he is not fully integrated - that's impossible. He is socially included as far as he can tolerate and is very much loved, there, and knows it! We do have a secondary special school place for him for year , though, in the discrete autism provision of an outstanding (not just according to OFSTED, from what I saw and heard) special school. I'm equidistant between 2 others - one has limited ASD provision and LA officer admitted they'd have no places for year 7 entry, as it's a 2-19 school,, but I would have been OK with him being there, as the HT is lovely (and was previously very helpful when I was exploring possible provision for DS1) and the other is just like your local - not only dire previous OFSTED, but a lot of scandal in the papers. For 8 years, we, or the local school have needed to contact them about various things and, for 8 years, they've been downright obstructive. I'd send him there only if I was too dead to home educate!
We know he's well socially included, btw, because he sings the rude versions of some songs :o