It works great for me. I've been using Linux since late 1996, and one constant has been that the kernel and its surrounding software is always evolving.
People with legitimate use cases against systemd shouldn't use it. People who don't want to use it should use distributions that don't include it. But systemd doesn't need to "die", open source is about freedom of choice. People who zealously hate systemd need to chill out.
The biggest problem people have with systemd is that it's constantly growing, taking on more functions and becoming a dependency of more software (for example, the Snap packaging system basically requires it). People joke that some day you won't be using Linux anymore, but GNU/systemd, (or as they've taken to calling it, GNU plus systemd) because it's ever-growing from a simple init daemon into a significant percentage of an entire operating system. People worry that some day, you won't be able to run a Linux system that's compatible with much of the software developed for Linux without using systemd.
Whether that's a realistic worry or not I don't know, and I don't really have a horse in the systemd VS not-systemd race (I'm using a systemd-based distro but that wasn't a factor in my decision), but I can appreciate being worried that systemd might end up becoming a hard requirement for a Linux system in a way that nothing else really is - you can substitute GNOME for KDE, X11 for Wayland (or Mir, I guess), PulseAudio for PipeWire and most stuff will still work, so the idea that systemd could become as non-negotiable an element of a Linux system as the Linux kernel itself rubs people the wrong way, as it functionally makes Linux with systemd a different target platform entirely to Linux with another init daemon.
pretty much everyone is saying pipewire is the future, because it does the job really well.
A lot of people say wayland is the future because it does the job better.
I don't get the resistance to systemd. It does the job well, and it does it better than most old systems. It does a lot of things, but it's because those are things that need to be done.