Hi. I was in the middle of a degree when my mental health took a downward turn. I was lucky enough to be able to withdraw from one subject and only 1/2 subjects that term. I then took the max. allowed terms off to get my head right. Between then and now I will finish with a lesser qualification and that is OK by me. I don't know how much of the course you have done but that might be an option.
On a positive note, it sounds like you have thought about this seriously and taking the opinions of your support into account as well. When the accessibility officer said about considering another course, were you given any suggestions?
There are plenty of options (?) in a mental health space and you listed a few in your post. There is also counselling. As for your life not being perfect, that can also help you depending on the area you end up in ... empathy for what a client might be going through. Many people who end up in this are have had their own issues to deal with as well. Your life does not have to be perfect.
You are not hopeless. Life can be unfair and we dont know when issues will occur. You did the best you could in the circumstances. Fwiw... I also failed a subject in my 1st degree.
I would be interested in hearing more about ...
"going to university has exacerbated my trauma. I get really worried that I'm not in the right course"
My experience was that if I was thinking about my anxiety, work issues, etc then it impacted negatively on my study. This can be different to being worried about being in the right course.
Finally, are these other students you could talk to?