I mitigate by shooting JPG most of the time, only going to RAW for shots I think will need the sort of editing RAW enables. So, maybe 10-20% of my shots are RAW, at most.

And for most of those, after edits, I'll export back into Photos as a new file, and remove the original RAW. Obviously, this is destructive, so it might not appeal to you, but it does side-step the RAW storage conundrum.