A funding crisis has forced services for 8,000 people with an intellectual disability and mental health issues, run by the St John of God Community Services, to transfer to the HSE in what has been described as the "saddest" day for the organisation.