Strange that most of the posts in this thread are people who can drive manual - given the statistics you'd think we'd be the minority, but apparently Mac users like to row their own gears.
In Statistics, it is known as a "Self Selection" bias ... in simple terms, the results are skewed because the survey wasn't forced to be purely random.
The manual transmission will continue be the least expensive to build and repair, so I don't expect it will disappear any time soon.
In the USA, it is pretty much down to 'dead man walking'. Witness how even BMW doesn't even offfer a manual on every model anymore. Personally, I've preferentially driven sticks for 30+ years ... but due to market limitations, I'm not optimistic about my next new car having one.
There's a couple of reasons why, one of which is that automakers no longer can typically charge a premium for an automatic ... nor do they want to, because an automatic today gets good gas mileage in the EPA test.
Add to this that how (particularly for a lot of the smaller volume manufacturers - eg, EU brands), the cost to certify multiple variations needs to be paid for, unless one purposefully offers fewer engine and transmission choices in the US market...and the Manual is what's usually cut.
Of course, there's also the driver element, which gets into a Catch-22: people don't buy manuals because they didn't learn to drive one ... and they can't learn to drive one without having one. Similarly, daily commutes with heavy road congestion that result in stop-and-go traffic are unfriendly to enjoying a manual transmission. Finally, more consumers think of driving as a chore and not only abuse it through distracted driving (cellphone/texting). In the meantime, the Automakers don't see any of this as their problem, particularly since a "less engaged" driver means a consumer who is more likely to lease and delegate all service expenses to the dealership ($$ profits), and they'll also be more gullible and willing to pay $2000 for a GPS navigation system that's really only worth $200.
...and if one wonders why Apple is interested in iOS for the automobile, simply keep in mind this "10x" markup on the digital technologies which are going into automobiles today...the GPS navigation system for the BMW 3 Series is a $2150 option...and its another $1,900 for "Driver Assistance Package" (a couple of cameras and a warning beeper/light)...etc.
In Europe...Double-clutch auto transmissions are becoming more and more standard on high-end sports cars because they shift quicker than a manual shifter, but the mid-end and low-end cars are all offered with manual transmission as standard...
Yes, DSG's have come into automobiles from the likes of F1 racing and because they do shift faster for better "0-60mph" times. However, that doesn't mean that they are all-around better: my wife's car has a DSG and it is utterly horrible when going slow (under 10mph) - - technologically, because these systems don't have a torque converter, they're very bad at being able to creep slowly ... such as when one backs out in reverse gear out of a driveway (a safety concern) or when in slow, heavy stop-n-go traffic.
FWIW, I just happened to read this article on the DSG topic this morning:
"Its time to raise the white flag on dual-clutch transmissions"
-hh