Unusual situation, chance me for transfer?

I agree with @ProfessorPlum …forget about rankings, they are just one piece of the entire decision. I think your top priority should be continuing to work on your mental health situation, and (assuming getting back into school is a part of that solution), finding a school that fits you, both acceptance wise and personality wise. Many, many, many people out there are pursuing their careers successfully from a community college or “lower ranked” school. Don’t let rank stop you from moving forward. Good luck.