Or it might be that your ex-school's modules don't line up with the semester content of the other college RN programs. I would be in the same boat if I ever decided that I want to get a ADRN or BSRN. I was at a diploma school for one year. But the content was all scrambled up and recombined in odd ways, so that none of it except perhaps Nursing I would match any normal college degree program sequencing.
Become an LPN and then bridge to RN? At least that would get you into nursing in 12 months. Here, LPNs have plenty of nursing home work at average $15/hr. Down in Beaver and Allegheny counties of PA, it goes up to $18-$20 or maybe even $22/hr, for LPN. That is starting pay for new grad RN in some places.
Repeating courses costs money and takes time. But it's always easier the second time than the first. Ya gotta do what ya gotta do. Unfortunately, the test grades have to meet a minimum and yours didn't.
I totally can relate to the anxiety attacks. (I can also relate to the chaos. The school I went to was definitely NOT ready for prime time the year I was there. Instructors quit. Director was fired, hospital had financial probs, etc.) I am a women who's worked in engineering, sci, and tech for over 20 years. Nursing was so much a traditional women's world that I felt like I'd been turned upside down. By the end of Year 1, I'd had enough. And it was the mother-baby-labor-delivery-OB stuff that really got me fed up and PO'd. I don't have children, I am not interested in raising any, and I didn't have any idea how much there is to all of that. It did, however, convince me that I was really too far down the road from all of that motherhood and family stuff and I just really wanted to NOT ever be involved with it at this late date. LOL.
Good luck. If you are still interested in nursing, don't let the _____ win. You just have to get back on the horse and ride. You'll turn 52 on the same date, regardless or whether or not you repeat nursing.