An MT is really only for performance or racing in passenger cars (trucks are different). AT is really for DD, comfort, etc. There are more of the latter because the majority of people use their car for DD. While sports car enthusiasts are prevalent, its nothing compared to overall car sales.
If MPG was better with AT, Europe would have far more ATs. MT gets better MPG and gas is expensive over there.