Thousands of children are on waiting lists for key psychological appointments, with more than 1,700 children already delayed by more than a year.