I was in a very similar situation to you at 30 in terms of lack of sex and social anxiety.

Move to a city, you can make it work.
There are lot of girls in a city you can talk to 100's and your social anxiety will get better. You won't get over it without taking practical steps. Don't get wrapped up in theory and over-thinking it - that can come when you've banged 100 girls.