Thanks for the extra info. So I think the problem appears to be that you are running around trying to make yourself useful - and if you adopt a servant role, that is how people see you, especially if you aren’t great at putting your views forward.
I think the most useful thing to do right now, rather than worry about making friends is to do a bit of self examination of what you want out of life, and also, why you have ended up fading yourself into the background.
I hate to bring it up but a bit of therapy might be useful, not to fix you, I don’t think you need fixing, but to help figure out what you want out of life - and also why you fade yourself out. Once you know what you want you can start to put yourself in a starring role, everything will get more colourful, and people will want to join in.
Other than get hold of a therapist (have consultations w at least 3, to figure out who you click with, and be armed with a list of qus), I would just stick up a sheet of paper or put a note on your phone about stuff you would be curious to try, and just start dropping them in - don’t edit - wine tasting course, wild swimming holiday, OU degree, training as a nutritionist, weekend in New York, walking the Camino de stantiago, poll dancing, yoga holiday in India, bread making course, erotic writing course, riding weekend... some things you will keep coming back to, and those are the things to try.
I would also take yourself on a weekly me-date where you get to do something you want to do - go to a cafe you’ve noticed, a pottery class, a pint and a book in a pub, cinema, gallery.. again just jot ideas down. You are a really funny smart woman and I think the first thing to do is find your sense of self
When you say you are a wag in a contained community, are you a military wife with a PT admin job on the base, or something like that?? If so it’s a really tough position to be in, as you aren’t core to that world, and you really aren’t choosing or getting much variety in the people around you. Is there a decent sized town or city near? If not, thank god for online for now, but you may want to look into your living arrangements going forward.
Keep posting