In Europe the uptake of manual transmissions is still 65 - 80% depending on country. Unfortunately in the US it's 3% and Australia about 9%!
Automatics will be pushed hard by the manufacturers due to driver aids though - notice that the adaptive cruise / autonomous braking etc. aren't available on manuals. Insurance companies will then push up the premiums for people without driver aids leading through to full automation. They wonder why people are so distracted when they drive... it's a self fulfilling prophecy really.
Still - all our family cars are manuals. We live in a city with little traffic congestion & even my wife's Hyundai Elantra is entertaining to drive with the 6-speed manual (if not exactly fast)