You're not supposed to care about it. IPv6 really has two motivating factors: the first is to simplify the IP stack, the second is to increase the scale of the address space. It's not supposed to be exciting, it's supposed to be a change we make because it obviously makes sense to do.

I also don't think IPv6 is a "failed technology" at all. If you've used almost any zeroconf service on an Apple product recently (AirPlay, AirDrop, AirPrint, HomeKit, so on) then you've been almost certainly using link-local IPv6. If you've used Spotify Connect or Sonos, there's a very good chance that's been over link-local IPv6. If you have any Thread or Matter smart home appliances, they generally communicate using IPv6 too. Most devices connect to Chromecasts over link-local IPv6. You've quite likely been connected to IPv6-capable Wi-Fi networks before and you probably never noticed. IPv6 is actually pervasive in all sorts of places.