The school in our case was similarly useless (and as you intimate actually made things worse). Massive sympathy to anyone going through some like this - it’s hugely distressing.
So sad. CAMHS were absolutely useless for us, it was only after the transition to adult services that something useful started to happen. Not sure money was the primary issue though - getting appointments wasn’t a problem, the whole way the support was structured was shambolic