It's supposed to be webpack plugin-and-API compatible, so if you already use webpack, hopefully not (much).

But is this constant turnover getting ridiculous in the web dev & JS ecosystem?

Yes. I simultaneously credit and blame facebook for starting it with yarn; after yarn, the trend of re-writing build tools seemed to become much more acceptable and trendy, especially since yarn (at the time) was multiple times faster than npm; you could argue it was worth it. But now we've reached a stage where the diversity of tools like npm, yarn and pnpm, now tools like ni (https://github.com/antfu-collective/ni) are emerging to manage the diversity.

I think this is getting out of hand, now there are n+1 of them.