As previous posters aptly stated, there is no sugar coating it. Nursing is not for everyone. Some people enter nursing for all the wrong reasons. There are few eminently qualified nurses, there are a lot of task runners and fewer critical thinkers.
Most importantly, assess your physical health and be realistic about the needed mental and physical stamina to get through nursing school, then to enter clinical field and to stay there for a while.
If you decide to give it a go, enroll in ADN/ASN program - shorter duration, straight path to RN license and an opportunity to get foothold in a hospital. Once you get into a hospital, that hospital would help you with paying for your RN-to-BSN, which would shave off significant cost of your continuous education.
Lastly, and probably most importantly, ask yourself: Would I enjoy caring for those that are sick? As a nurse, you would be patient's advocate and a last line of defense.