^^^This exactly! I would be worried if someone wasn't scared when beginning their nursing career. Being scared means that you genuinely care about the outcomes of your patient! Just know, when working in the hospital setting, you are never alone. There are always people and resources available to help and support you.
If you don't have any financial concerns with obtaining your BSN and you want to do it for satisfaction, I say GO FOR IT! You are probably more likely to regret not doing it than doing it! It can't hurt. You are never to old to expand your knowledge. Good luck!