My first 4 cars were manuals. The last one was a mistake, as I was already ready to go to automatic by that point but my friends convinced me to get another manual. I was already having back problems, and operating a clutch pedal is bad for your back. Are manuals going away? Yup, most definitely. Will I miss them? Not in the least.
All of the advantages of manuals have been going away, and the various automatics take the top ranks nowadays. Of course there are many different types of automatics nowadays, from the traditional slushboxes, to the dual-clutch, to the CVT. Just looking at the traditional slushbox automatic, and ignoring DCT and CVT, slushboxes are taking all of the crowns. The fastest accelerating versions of cars are now the automatics. The most fuel economical are now the automatics. They even take the fastest on-track performance crown most of the time now. There is nothing that a manual has an advantage in now, except giving the most back aches, and most frustration in traffic jams.
I don't see what the nostalgia is for manuals anyways. Why is there no nostalgia for manual chokes? What about manual crankshaft winding starters? Carburetors vs. fuel injection? There is no nostalgia for those because all of their replacement technologies have made life much more convenient, with no downsides. The same is now true of manual vs. automatic transmissions.
But this is all moot now anyways. At the dawn of the electric motors, which don't even need transmissions, this is a debate about the best buggy whips.