The reason is not what some might think. Once, a manual transmission was considered an economy feature. Cars with manual transmissions had a final drive ratio tuned for fuel economy.
Today, a manual transmission is considered a sporty feature. Cars with manual transmissions today are often tuned for performance, not economy. This can be seen in both the gear ratios of the transmission and how the engine is tuned. The result is a car that is zippier to drive, but less efficient.
It is very difficult for a human to keep the engine within such a narrow RPM band for efficiency, without accidentally lugging or stalling. So, they will likely spend their time with higher RPMs which miss these opportunities.
That point is nonsense. Changing gear is almost completely automatic and takes very little time. Also completely inapplicable on motorways where you're basically always in 5th .
Automatic cars do get better mileage, and AFAIK the concept of “manual” makes no sense in a future where we switch to electric cars to reduce Co2 emissions.
The article author’s point about using additional limbs making it harder to text and drive is well taken, but I think we are going to have to continue to work on ways to make texting while driving either safe or impossible in an electric/automatic future.