Hello!
So, he has no friends, he's not keeping up with the work, he's hardly able to write anything down, he's finding the social skills support to be of no value in the way they're doing it (we can't see people! We can't cope with more than a small amount of social interaction because our brains have nowhere to file it! Parking us in a whole group is like sticking us in a battlefield with all the guns being fired and bodies flailing about all over the place, then telling us to play nicely!)
So, he's blanking out in class because of the overload, the teachers reckon he needs one to one support...
...and the SENCO says he will just have to learn to cope?
Does the SENCO, by any chance at all, also believe that children who are blind can just learn to see, or that children who are deaf can just jolly well learn to hear? What about the ones in wheelchairs? Are they just going to have to learn to stand up and walk?
Words nearly fail.
He can't just make this go away. And they're not taking it seriously.
Everything he's doing is a clear indicator that the existing support is not working. They need to start again, from scratch, working out what actually helps.
Definitely get in touch with the links suggested already.
I went through school with no ASD support (there was none in my day) and it was hell. I still can't access higher education because it's too difficult for me, so I do know what sort of challenges he's going through. Brilliant that he has you for a parent, fighting for him.