I can answer this. I have a very similar workload to OP. I've found myself with resolve, affinity photo, chrome, vscode, spotify, ect open simultaneously, and have had absolutely zero struggle on my 8gb air.
If you become "enlightened" you can notice that sometimes when you, say, open your spotify window after a long time elsewhere, the spotify is briefly unresponsive. Not in a way you notice, more in the sense that if you are looking for it, you can see hints it is swapping.
The only time I wish I had more is when I got into iOS development and began running VMs on my mac.
Modern SSDs are resilient enough that most people will never wear them out with anything resembling a normal workload. Unless you're constantly swapping for several hours a day, it just isn't going to matter.
That's a conservative estimation of the lifespan (how hard you can hit it while maintaining a very low probability of SSD failure). The more interesting question is "How likely after n years is the SSD to be the first non-replaceable component to fail on this laptop?" I don't know the answer to that question, but I'm guessing it's a good long while before the answer to it goes above 0.5.
Apple have been shipping laptops with non-replaceable SSDs since around 2017. Anecdotally, we hear so much worrying about potential future SSD failure, and yet so few people saying things like "I bought an M1 Air two years ago and now the SSD has died".
SLC makes sense for almost zero use cases, even in a data center. It's simply the wrong tradeoff between capacity and performance. It's not enshittification that you can now have a cheap multi-TB SSD to hold a large collection of movies and games and still have an SLC cache for the small portion of your data that isn't mostly static.
My current and previous MacBooks have had 16GB and I've been fine with it, but given local LLMs I think I'm going to have to go to whatever will be the maximum RAM available for the next model.
Similarly, I am for the first time going to care about how much RAM is in my next iPhone. My iPhone 13's 4GB is suddenly inadequate.
My MacBook Pro M3 has 36GiB RAM and does all of the comment above + music producing (dozens of VSTs on some 1-2 dozens tracks) + projection mapping and can run some LLM models locally like the Mistral ones.
I've only managed to hear the fan when chatting with a LLM, for anything else it's been an absolutely silent beast.
I have M2 Pro 16GB from a client. It's comfortable for typical dev work - tons of tabs open, Docker, VS Code etc. Though the swap is about 20GB now and sometimes it lags. Still it beats any Intel or AMD laptop I ever had in terms of performance. This machine is on a whole another level.
My own machines are M1 Max 32GB and they fare slightly better.
I have an M2 Air with 24gb and it has no problems running Brave with 800-ish tabs, development workloads (a bunch of VSCode projects, several docker containers, lots of iTerm terminals), low-end CAD and 3D printing apps, CaptureOne and a bunch of Electron apps in parallel with room to spare. I've found I can fit more into those 24gb than into the 32gb of the Intel Mac I had before that (however that's possible).
Almost all of them have already been read and are waiting for me to build something to pull the links out of Brave and download/archive/index them somehow. I've been wanting to do this for a long time, but haven't yet.
It would be quicker to manually move the URLs to a text file, then supply that as input to a tool like wget. However, you will almost certainly end up with either un-necessarily bloated files, or saved sites that don't quite work.
I still stand by the spirit of my original comment - there probably isn't enough information content in your 800 tabs to make this endeavour worthwhile.
Why am I not surprised that an apple fan uses Brave - a browser that offers literally nothing but 100% false claims of improved privacy and performance?