Fear of failure

I am feeling very afraid of failing right now and I am frankly embarrassed at how dependent I am on my family financially right now even though I’m in my 30s. I am not even sure how I let this happen. I guess I sort of didn’t see it until it was too late. I need to get away from them and more independent but I’m literally petrified with fear suddenly. I simply have to be able to support myself and I cannot boomerang back to them yet another time in my life. Yet I have some kind of paralyzing existential fear of either not liking a new job or if not being liked at it. Somehow the idea of having the same job for more than 1 or 2 years is terrifying to me. Is that unheard of?

I can really sympathise with that feeling. It sounds to me like you're living under stress...having a kind of flight/freeze reaction. Idk what your familial relationships are like, but personally I've always striven for independence, and it's especially hard to get if you are getting a lot of conditional support from people...as in support that actually comes with a high hidden cost.
What kind of work are you looking at? Have you considered temping, or looking for training opportunities?
I know that it's really difficult to work hard if you don't have a clear idea of where it's getting you, also.
I've done an exercise where you envision your ideal future, and write about it, what you would have to do/change, and what your actions could lead to in the worst case, and what those actions are likely to lead to in reality...so you can aim for the stars, you might land in the gutter, but you're not likely to get stuck if you keep aiming up and focus on the fruits of your labour.
I'm sorry your struggling with this. I do know it is absolute purgatory, and it's not necessarily something you can just pull yourself out of without some help