As a general statement: No, your chances of being a nurse are not over.
Getting into a nursing program boils down to two things:
1. The criteria for admission set by a specific program.
2. The other applicants applying for the same program at the same time as you.
You need to find out the admission details on schools you plan on applying too.
Things to make note of are:
Qualified by your state's BON as a program eligible to sit for the NCLEX
Cost of program
GPA requirements and how it is calculated for admission purposes (overall GPA, only pre-req GPA, etc, etc)
Course Repeating policy
Entrance exam (TEAS, HESI, etc) required scores and amount of attempts.
Pre-reqs, Co-reqs, and supporting courses
Stage at which you can apply (Some programs allow you to apply with certain prereqs outstanding. They are to be completed by the time you start the program)
How they determine admission (points system, lottery, waitlist, etc)
How they determine any tie-breakers
I'm probably missing something in my list of what to look for, but that is a general idea. If, by some weird chance, the school you are currently at won't accept the C or a repeated course then find a different program.
Many people had a rough go at their first attempt in college, myself included. However, they turn things around, get in to a nursing program, pass the NCLEX, and become excellent nurses. Don't give up over a single 'C'.