The answer used to be Yes. 32GB RAM was a spec I'd commonly try to get. As the other commenter has indicated, contemporary browsers have decent logic for unloading open tabs from RAM. Likely it's one of the many improvements made after Google Chrome received strong criticism for it's RAM consumption.
I think tab unloading in Firefox might predate Chrome. I was using an addon for it called Bar Tabs Heavy in the late 2000s / early 2010s, and I know it was a successor to another addon (which I think was just Bar Tabs).
Firefox doesn't load tabs after a restart until you click on them, and I use a tab unloader so tabs also get unloaded after a few hours (mentioned in my original comment that started this chain).