I agree with others who encourage more investigation into potential career ideas - especially that you should try to shadow a nurse for a few shifts to see if you could see yourself in a similar role.
I was not originally big into science before I started the nursing program; mildly interested at best. Even now, I am much more excited about psych and hospice nursing, two areas that are pretty holistic compared to some other specialties. So, I didn't find that I needed to be a complete braniac. However, it is imperative that you have the discipline to learn the processes behind disease, understand the actions of medications, etc. A HUGE part of pretty much any nursing job is teaching, and you don't want to draw a complete blank in front of your patients and their families. It just helps to have some motivation to learn the science of it, even if it's not your main gig.
If you like helping people, aren't completely about the desk life, and have some struggles with anxiety/depression, maybe consider some of the following too: art, music, or recreational therapist; social worker (kind of desk-y, but there are jobs that involve some field work); teacher (e.g., pre-K, special ed); health educator; massage therapist; reading specialist; etc. Maybe check out some online aptitude tests like the Strong Interest Inevitable, MBTI, etc. They're not the definitive answer on what's best for you, but they are a great place to start gathering options. The bls.gov website has a pretty great section that details a ton of different career options, which is helpful with research.
(I would also suggest dental hygiene as a possibility if you think you can cope with some science and the occasional case of stinky breath, but prefer something that may be a little more repetitive, a little less life and death. I often wonder if I might love that even more than nursing if I could go back. I think it's similar earnings to nursing and pretty sweet hours by comparison - while it's doable, night shift is no friend to the anxious.)
From reading your post, it sounds like your biggest drives to pursue nursing are that you need to pick something to stick with and that your family approves. For me, that would not be enough to push me through. What else, if anything, gets you excited about the work of a nurse?