I think some of this is generational - we grew up with ICE cars around us, learned to drive in them, fawned over the nice ones from a distance, etc. My children I suspect will have a different view of ICE vs EV when they get to driving/car buying age. We have some emotional attachment to the idea of ICE because we have a lot of memories linked to them.
I have had a Superb II CR170 Combi for the last 6 years (a manual for a bit over a year until it was written off in a collision and a DSG for the last 5) and I have to say it's an excellent car, fast, roomy and handles pretty well for its size and weight. But apart from the power delivery and economy, there's nothing special about the engine, it's up there doing its job but the noise it makes is nothing special - I'm aware there's an engine up there but that's it. It could easily be replaced with a hybrid or electric drivetrain and it would make no difference to the car, and I will be replacing it with one of those drivetrains when the time comes. I get out of the car and it's "good job car" but there's no longing to jump straight back in and go for a drive for the hell of it.
Now some of this I can say because I have the luxury of also having a recently acquired Porsche 944, a car which would not be the same at all if it had an electric drivetrain. There's a real sense of occasion from the moment the starter swings over to fire it up, there's a fruity exhaust which lets you know it's there all the time, and once it's warmed up it performs the way only a highly strung petrol engine can, screaming up the redline then a pop on overrun at gearchange. I never get out of that car without a smile on my face, and that's just because of the car/drivetrain. I'll take the long way home just to drive it a little bit further and enjoy the engine a bit longer.
A while back at a Cars&Coffee meet a few of us were discussing this exact topic, and one of the lads made an interesting comparison to horses. At one point, horses were every day transport for the masses one way or another, and most horses you saw were unremarkable working animals pulling carts or carriages or ploughs or all of the other things that required *ahem* horsepower. Horses existed for sport/leisure too but that was a marginal use case. Nowadays, ICE (and increasingly EV) have completely replaced horses for working purposes, and leisure/sport use is all that's left, but that's still there and is a bigger industry than it would have been a century ago. This is most likely where ICE will end up, leisure/sporting use and if horses are any indication it won't be going away any time soon.