Disclaimer, I am not from the US. I am Brazilian, but now live in Europe.
All the cars I had throughout my life (for the past 12 years) have been manual. I don't ever see myself buying a car without 3 pedals as long as manufactures keep making them.
I know now-a-days manuals are slower, less economical (new high end cars, at least) and less practical. But the feeling of executing a perfect heel and toe downshift is just awesome!
This year I got a new BMW M135i with a manual. The owner of the dealership made a point to meet me, as he was impressed by my choice of car. Not only it was a manual, but also orange. He says 99% of cars he sells are black, gray or white. And last year, out of 1500 cars sold, less than 5 were manual.