Libreddit does work, but not all instances of it do.

beehaw - tight-knit diverse, lgbtq and positivity reddit

Out of the open platforms, I use:
Reddit: Lemmy, Beehaw, Kbin
Twitter: Mastodon, Calckey
Facebook: idk nothing really plus I don’t even use Facebook that much anymore

I may occasionally use proprietary ones like Twitter, Tumblr and Threads.

On the other hand, it makes spammy articles from content farms the primary resource to find answers.
And either way, not everybody is doing this, so Reddit retains part of its usability, which still exists, and some portion of people will still use Reddit after the API changes.

They did make a poll and then later announced they’ll be banning underage anime art and IRL imagery . But not art of cute/short characters because it’s impossible to discern if they’re over 18 or not. It’s the whole Pokemon debate all over again.

So, it is recommended to either join one that fits your niche or maybe to self-host?