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.
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.