RN vs. LPN (Please Give Advice)

Good Morning. I posted this on the LPN board and got a few responses but it was recommended that I ask on the RN board. I am 43 and had 3 years of college over 20 years ago. A year ago, I finally restarted school and went to the local community college and loved it. I got a 4.0 in the classes and loved the process of learning. The nursing wait list is a year and I decided to switch to MCI in Va. Beach. I took the testing and did great and was accepted. However, the first mod I had problems at home and hugely failed A&P. Embarassing and terrible. I had made straight A's in the prereqs at the school and got an A in the other class of the Mod. The school has offered for me to start in the LPN program. I have seriously started doubting my abilities. I was also the oldest person in the classes by far. They also offered for me to do RN program in Newport News but when I asked about LPN, they totally withdrew the offer to go to the RN program and said it was full. Part of me thinks that I am scared I will fail again. You can only fail 2 classes in 15 months or you are out and it is all wasted. The classes is strict and you can only miss one class in a five week period or you are out. My question, is do LPN's even have many employment opportunities. I had wanted to work in a hospital and I am hearing they aren't hired. Also, will I make enough money to justify a 30,000 school. However, I really need to have a job. I am in a bad situation at home and need to know that someday I could take care of myself and my daughter. The sooner the better. PLEASE GIVE ADVICE/ INFO.