Is it normal to be so scared of having a job?

I'm no Dr. but it sounds like maybe you have a social phobia. I used to have a really bad case of it but it got better with the help of talking to a therapist. Talk to you general practitioner. Your Dr could judge if you need therapy or meds or whatever. Good luck.

There's nothing wrong with preferring an introverted job, but -needing- one is too difficult a problem not to find help for. It's a terrifying world to start being an adult in, but these people are right- you have to deal with it. The sooner you find a way to do it, the better.
However, if you're incredibly paranoid in any social setting, I wouldn't jump into the sharktank yet. Talk a doctor, if you can't afford one and you need medication at least, look into clinics who might help.
If you can learn to adjust without such help, do it. Ask family to introduce you to people and try to put yourself out there. Talk to strangers casually. Etc.

I'm in a similar situation. Not only do I have social anxiety, but I can't do certain jobs due to embarrassment, pride (do I really have any?) and the fear of being recognised. Consequently, there are few areas in my state that I can't work in. I have been wanting to be a horse jockey, but I have to learn how to ride horses as well as to get over my fear of them. I also wanted to be a dominatrix. In fact, I still do. However, my therapist advised me against doing this currently. My therapist is going to help me with this. You should see one too.

You've gotta get out of that comfort zone, don't worry its not so bad on the other side. Change is difficult but you've just gotta go for it.

Be a security guard and work graveyard shifts. I am extroverted so I'm not scared of people but I hardly deal with people. Google security companies in your area and give them a call. Graveyard shifts are pretty easy to come by because no one really wants them.

Edit: Just occurred to me that you might not know what a Graveyard shift is. It's an overnight shift, mine is 10 p.m. to 6 a.m... usually they are also full time jobs. I've never had trouble getting hours as a graveyard guard. Also I had no security experience beforehand so no experience isn't always a big deal.

Once you get used to it you will talk to people without thinking about it. I took nerve pills for a couple days when i had to start taking to customers and it helped me relax enough to build the habit. After it works and you feel you've done a good job i suggest you quit taking them so you can do it on your own. You don't want to have to depend on such things and, IMO you're not truly at your best when taking them.

"I'm desperate to find some form of work that suits my shortcomings" So you want to run away from your problems and hide:(

You need to toughen up Buttercup! You don't need meds and shrinks that just re enforces your belief that there's something wrong with you, you need confidence and confidence is something you earn. Did you learn nothing from 'Fight Club'?

My advice: I'm guessing you don't even lift so why not take the 100 push up challenge, that will give you a goal to achieve and when you achieve a goal you earn confidence.
You can PM if you want Bro.

Wouldn't it be a lot more productive to overcome your "shortcomings"? It certainly would make your life easier. As an adult, it's time you took a stand and got your act together, especially in this time of need.
You must NOT let these things control your life. You are the boss of you.

Actually there are more and more lady drone pilots....