Fear of transcript holding me back

Hi all. I'm currently a 2nd year science student at a Canadian university. Throughout these two years I have been battling depression but was only recently officially diagnosed with it by my doctor. Because of my struggles and a poorly-scheduled timetable, I landed on Academic Probation at the end of my first year. This second year, my depression has gotten worse and I am unlikely to achieve the average needed to be promoted back to Good Standing, even though I technically will not fall under 50% GPA. I am trying with all I can. But even with that said, I will most likely have to be dismissed from my institution for 12 months before reapplying.

Now I have been interested in nursing school for some time now. My plan now is to take courses at a community college to boost my GPA, take the prereqs, and then apply to a BSN program at the same community college.

My transcript from my post-secondary institution is not the best... I have several A's and A-'s, B's and B-, some C's, but I have 4 F's. Yes, four. That brings my average down a lot. And along with that, it will probably end up saying I have been dismissed from the institution for failing to meet Good Standing requirements. My high school transcript however, was a 93% entering into university from the IB curriculum, and I have 18 credits worth of transfer credits.

I have recently started medication and want to be optimistic about my future, but still realistic...Even if I do incredibly well in those CC courses + prereqs for nursing, will they never consider me based on the fact that I did not successfully stay in university at one point?

Thank you for reading and good luck to all your future nursing endeavours!