When you boot up your Linux, it will mount the root file system and start one program. That program is systemd. Everything else on your system will be started through systemd or processes that systemd started.

That's why it is important, everything else on your system is build on top of it. That's also why it is difficult to replace, if you use something other than systemd, you need a completely new set of config files for that other thing or your software might not work properly. Most distributions have given up on that, as it's just more work for a niche audience, and they just require systemd instead.

As a regular user you don't really have to care all that much, most stuff systemd does will happen automatically in the background and be setup by your distribution. It can still help to get familiar with systemd tools like journalctl as that's where all your error messages go and systemctl is how you start, stop or disable services on your system. If you use something other than systemd those tools won't exist and something else will take their place.

As for why people don't like systemd, it follows the kitchen-sink approach to software and does a lot of things at once. It replaced a whole zoo of smaller utilities like inetd, syslog, cron, atd, ... Some people dislike this loss of modularity, while most the rest are happy that they have one tool that does all of those things well, especially since systemd can do a lot of those tasks better and in a more unified way than previously.