There are always the exceptions, and I often talk about the exceptions of nursing school students who don't do well in classes and on exams but are great in the clinical settings. The problem for many current nursing students and new grads is there simply are not enough positions for the number of graduates. In the past, schools may have bent the rules a bit to encourage or enable students to continue, even if their grades weren't officially passing. There is no longer a reason to do this, and in fact it would be a great disservice to those with marginal or failing grades to stay in their program. First, the NCLEX is an unforgiving test and there is a very high correlation between doing well academically and passing the NCLEX. The worst outcome might be to spend 2 or 4 years in nursing school, and the money, and the loss of income while in school, only to sit for the NCLEX and fail. At that point, a student would (rightly) complain, "They took my tuition, allowed me to waste those years, knowing I had little chance of getting my license." The next problem would be actually finding a job with a transcript full of B's and C's (in most programs a 70% is failing--so you're right on the edge, worse if your school's requirement was a 75%).
There is a huge difference between early clinical experiences (where you're basically interviewing patients) and the later clinicals like critical care where you need to know everything taught in the classroom. The didactic portion of the program isn't 'paper pushing' it's the cornerstone of the nursing education. One of the problems with nursing is that people who want to be nurses often have little idea of what the job actually entails. I can't count the number of student nurses who long to, 'sit and hold a dying patient's hand'; I know of no employed nurses who have ever had that opportunity--no matter how much they would like to offer such support. While words like 'caring' and 'supportive' are often associated with nurses, it would be more accurate to associate nurses with traits like 'intelligent', 'competent', and 'decisive'.
It's wonderful to have hopes and dreams, but they should be tempered with the realities of life. Be thankful that you didn't waste the additional 475 days and the cost of tuition on a program that probably wouldn't have led to success. Maybe it just wasn't 'your time' to attend nursing school. It's tough to do this program without burdens of working two jobs, recuperating from an auto accident, and living far from home. Maybe you'd be successful if you were able to devote the time and energy without distraction. Think about ways to get to your goal: maybe a school closer to your home, maybe going part-time... You might be able to do this, but only if you humble yourself and not refer to the important classroom work as 'pushing papers' and thinking that nursing school is a 'piece of cake'.
Don't give up on your dreams, but don't minimize what nurses do, how hard school is, or how hard it is to get to that dream. Best of luck to you!