All cars will be automatic once petrol and diesel cars are banned/taxed out of existence/fall out of favour.
25 years ago, I'd have said that only learning in an auto was severely limiting yourself in your driving career; now, it's probably no big deal.
Then shortly after that (if not before), they'll be even more automatic, as you won't actually have to (or even be allowed to) actually drive it yourself.
But back to your actual question, as PPs have said, if you like more control (and not necessarily just to be a speed freak) - especially in snow and ice - and slightly better fuel economy, a manual can be better.
On the other hand, autos are much easier and smoother if you sit in jams a lot or frequently tow (particularly a caravan, horsebox or other very large trailer).
My first car was an auto, my second was/is a manual and when I eventually get my third (I keep cars for a loooong time!), I'm undecided, but swayed in favour of an auto - mainly because we've recently bought a very old caravan and I now have a level of disability which would probably mean that an auto is easier.
Do you have a good friend or family member with an auto, who would let you borrow it/swap it with yours for a day or two? If it's a big outlay, you could even consider hiring one for a few days. Best scenario would be if you're going on holiday abroad before you buy your car and can hire the car that you would have needed anyway, but get an auto.
Anxiety, dyspraxia, lack of confidence or other disability/health/pain/learning difficulties aside, I don't think it will make as big a difference as you might think - unless you do a huge amount of stop-start driving, maybe - as it just becomes second nature to change gear and you don't really think about it, so an auto doesn't end up meaning that big leap into much simpler driving.
Definitely both try one for a few days if you possibly can and then decide.