@Bowlofcereal
My DC was the same, and managed well in mainstream school with Autism Outreach help. They come to the school and help the child 'negotiate' the pitfalls and issues they may have.
At my DC school they also took 'neuro-typical' kids who were not 'understanding' what my DC had said/done, and helped them see that my DC wasn't intentionally being rude/annoying etc
This help is the only reason my DC managed as well as she did in mainstream. By the time she was in secondary school, she had learned herself how to 'explain' ASD to any new friends she made, which meant she no longer needed help from Autism Outreach.
I think you're right to question whether another school might be a better 'fit' for your DC, but you need to base it on what help is provided.
Also remember, that your DC is going to become more 'independent' , and soon. It will be better if he can learn how to 'integrate' with others who are not ASD etc, rather than to have others fit round him, if you see what I mean ? Because he will be on his own soon, and the better 'prepared' he is, the better he will cope.
As an aside, it's pretty usual for ASD kids to have 'meltdowns' when they come home after school. It's because they are 'learning' to 'adapt' their 'behaviors' while in school, so that they 'fit in', but the stress of that effort means they need to 'let off steam' in a safe environment i.e at home, because they simply cannot maintain the 'act' for 24/7.
My DD has just finished her 1st year in University, and is looking forward to her 2nd, but she still has 'meltdowns' occasionally, especially after a prolonged spell with her NT friends. (And she still 'stims' in private every day too.)
Your DC will overcome his difficulties in being 'around' NT kids (and it's often more 'accepted' among boys to be very 'direct' , 'honest ,to the point of rudeness, and 'literal', which is going to help him in the long run), but it will help him to be 'immersed' with NT kids, rather than kept apart from them. (I suppose it would be a bit like learning to cycle a bike in the classroom, but without ever having to try it physically ?)