I gave it a few minutes of trial and then disabled it.
With memory prices increasing, many people unable to afford new machines, and web browsers being one of those things that can potentially take a lot of system resources, I wish the Firefox team would prioritize CPU and memory performance of the core engine for users with lots of tabs.
I have stuff like 'Auto tab discard' installed but it seems to break other things, like 'Close Duplicate Tabs'.