It's true that alternators have a somewhat limited lifespan. They have rotating electric contacts that need to conduct electricity and rotate at the same time. Those contacts are wearables, and even though they are only used for the magnetizing field, not for the actual produced current, they still have to be capable of conducting great currents and aren't trivial. A hypothetical permanent magnet alternator that would use DC-DC converter after it to adjust voltage to be correct at all engine speeds would be far better. For example hybrid vehicles lack alternator, they have only motor-generators (of the permanent magnet type) and indeed the 12 volt battery is charged through a DC-DC converter. Your battery however has usually enough capacity to drive to a garage should the alternator fail.
Another similar component that may fail is starter motor, because ordinary starter motors aren't beefy enough to be useful in stop-start cars. Maybe the newer integrated starter-generators are better than starter motors and alternators. But they are often driven by a belt, that can fail too.
Everything that's made from rubber degrades as a function of time. This includes seals, gasoline lines, tires, CV joint boots, belts, etc. Water pumps require a seal too and that can fail, as can bearings. Though tires can be monitored so it usually isn't "without any warning", a car with gasoline leak or CV joint grease leaking can be driven for short distances, and a broken seal won't ruin your trip. Broken belt is more catastrophical though, especially if it's the timing belt.
In my experience, in many manual transmissions the synchronizers are prone to wear. However, usually you'd just accept the wear because transmission replacement or overhaul would be so expensive. However, clutch wear is something you can't accept, once it's worn then it's worn. Manual transmission cars are notorious for needing clutch jobs. However, these are gradual not catastrophic.
Anything complex can fail in an expensive manner. So for example today's complex automatic transmissions, whether of the torque converter type or whether of the dual-clutch type, can and do fail. Sometimes catastrophically.
Diesel vehicles are notorious for having lots of easily broken components: fuel injectors, particulate filter, urea injection, etc. And you won't find a modern diesel without turbocharging. Turbochargers can get damaged too. Fortunately, these usually won't ruin your trip although they ruin the state of your bank account.
Power steering racks used to be hydraulically powered, and the seals there eventually fail, leaking power steering fluid everywhere. They won't ruin your trip, though, although it's a real pain to park a car without power steering fluid in it.
Any bearing is prone to needing replacement at some point of time, although many do last acceptably long and give an early warning.
The 12-volt battery isn't as durable as for example typical electric vehicle batteries, so replacement at some point during car lifetime is almost certain. But death can be sudden and it may annoy you if you can't start your car anymore and don't have a spare battery (keeping a spare battery is a poor idea because lead-acid batteries really like full charge, have a limited lifespan and a spare battery would get slowly self-discharged and even if not its limited calendar life would be a problem). So I disagree about your incorrect assessment of 12-volt battery failures not being catastrophical.
Engines wear too. A typical engine in fact may last less than an electric vehicle battery! Sometimes engine failure can be catastrophic, e.g. timing belt snapping or so fast oil leaks (fortunately rare) that you won't have time to stop the engine.
Spark ignition today is fortunately very reliable since we have usually per-cylinder ignition coils, no distributor, and if a spark is disabled from one cylinder it's detected and fuel won't be injected so your catalytic converter won't overheat. However, theoretically the engine control unit could fail. Or its relay -- I once had that happen in a 1989 Opel Vectra. Good ECU but crappy ECU relay.
I'm sure I missed maybe more than half of the most likely components to fail.