You're 47 but I'm 22 and feeling the exact same way, so I hope this provides some comfort to you that no matter what age you are, you're not alone. I'm also wanting to go back to college but my anxiety is preventing me from doing so. I'm working from home right now part time so I basically feel like I'm doing nothing as well...and going to school again is scary.
You have so much life experience at 47. The fact that you even want to go back to school shows great strength. Most people at 47 would have totally given up the idea of going back to school, but you're actually contemplating it. That shows a lot of inner perseverance and potential.
The best advice I can give you is advice I've also been telling myself - go back to school because its something fun, not for any other reason. Do not put any pressure on yourself to succeed or to get to the end of that marathon, just take it in baby steps and do it only for the fun of it, only for the experience of it. No pressure at all. If you work on keeping this mindset about it, you won't get overwhelmed so easily because you won't put so much pressure on yourself.
Be very weary about technical schools only because I also went to a technical school, and I ended up spending a lot of money and didn't get a job in the field. So just make sure you really do your research on it and make sure its a lucrative field and that there are actually jobs available and its not a saturated field.