The vast majority of the cars on our roads in the UK are still manual, but the tide is changing and not just with the introduction of EVs. There exists a legal quirk whereby you're not licensed to drive a manual car if you've passed your driving test in an automatic. Until that legislation is updated, I expect there to remain a strong demand for manual transmissions amongst learner and new drivers.
Personally, I'm of an age where simplicity and convenience are valued more in my life. Parallels include choosing Apple devices where I'd previously been all-in on Windows, Linux and Android; consoles over gaming PCs; and I'd also include home automation despite the initial set-up. Both our family cars are currently (non-EV for now) automatics and I can't see myself or my partner ever voluntarily going back to manual cars. I can push a single button to start, select drive and go. Even the handbrake is automatic.
Anecdotally, my social group is very much of the same mindset. Increased traffic on our small island has all but removed any romantic idealism around driving a sporty manual car on an open road. Now that driving here is more of a chore than a pleasure, anything that helps ease the burden is going to become the default.