I think inclusion could work, or could at least work better if there were proper funding available and it wasn't a battle to get that funding or support. Often by the time any support has been put in place, the child has reached crisis and they've often got really negative associations with school.
I do think we also need to acknowledge that for some children, a large mainstream school will never be the right place for them. I teach in secondary where perhaps it's more obvious, but there are some students who can't cope with being in a class with 32 others or busy corridors, or 5 transitions a day plus the unpredictability of maybe having a cover teacher or a room swap or something else that's changed.
Fwiw, I don't think this means these children won't ever work or be successful. There are loads of jobs you can do where you don't have to be in a crowded building with 1000 others - plenty now where you can work from home and control your environment, and this is what they need and it will never be possible to do that in a large school.
And yes also to competing needs. Child x needs a quiet and calm environment in order to focus, child y has unpredictable tics, child z needs regular movement breaks, child w has anxiety and doesn't like working with others and needs to be sat by the door, but child v also needs to be sat by the door, and they struggle with appropriate social boundaries.
Inevitably, someone's needs aren't met, and they get upset and maybe this leads to a meltdown. And inevitably, someone (parent, SENCo, senior leadership) will ask why you weren't meeting their needs even though you already feel absolutely awful about what has happened.