The $25k car is going extinct?

You can still buy a new subcompact car (like a Renault Clio or Skoda Fabia) in Europe for under 20k EUR.

The more interesting question is why these cars disappeared in the US. And while many of the factors discussed here are true for both EU and US (inflation, interest rates, manufacturer profit margins etc) I am surprised no one mentioned the 'SUV loophole' of US regulations that effectively boosted the SUVs (off-road vehicles are classified as non-passenger automobiles with everything that entails, notably much less stringent emission standards) and made the small cars unprofitable to make in comparison.

Because a big part of owning a vehicle is summer roadtrips, ski vacations, visiting family, moving stuff. An SUV is simply more convenient. I've also found road maintenance is getting worse where I live, it's almost necessary having an SUV or truck just to navigate the suburbs.

Also the (semi) compact crossover has kind of killed the compact car. You get more space, better ground clearance, for a decent price.

99% of people with an SUV will never use the "sport utility" aspect of it, and they could do all of the things you listed better with a minivan (Sienna/Odyssey/etc).

But the driver would have to sit lower in a minivan. Which is what SUVs are really about, the ego boost one gets from sitting higher up (and the associated feelings with being able to not have to settle for a minivan, and being able to waste a little money).