I love my three pedal Miata. I'd buy a Camaro or other performance car with a manual, 100% sure of that. But, as much as I love DIY shifting, I'm with the great unwashed masses in the camp of buying an autobox in a daily driver/commuter/etc car. First, resale blows on manual "regular" or luxury cars. Second, good lightening-fast transmissions are sweet in sports sedans. Still want three pedals in my 911, but in my sedan? Nah.
Mercedes tried to sell us manuals, literally NO ONE bought them. BMW has seen percentages drop dramatically. Subaru once had 50% manual buyers not long ago, and that's a fraction of that now. There's pretty much no market for "regular" cars with manuals. No one wants a manual Forester anymore.
Some makes have tried, persisted, and ended up with unsold inventory. It's the fault of buyers. They want autos.