Yes, if you make a living with photography, I can't believe you have shot only a couple TB of data.
You need a much larger centralized data store and then you sync some subset of that to the local SSD.
What is a good, long-term storage? Likey a NAS with RAID that has the abilty to keep selected files sync'd. Also you need a few redundant ways to backup the NAS.
I know you're talking to OP but quoted me, but some people shoot like it's the film days are are really intentional with each shot and take their time. Different strokes for different folks. For me, I'm somewhere in between. I try not to just hammer the shutter down even though I can shoot 42MP RAWs at 10fps, but I'm no lightweight.
Also sometimes people say they're a photographer but they're a hobbyist. Or it's only a part of their job. I know that my catalog isn't massive, but a lot of my older stuff is shot on some pretty old DSLRs that were 8, 10, 18MP and some of the early stuff was I think only 10-bit and 12-bit RAW, and when I was shooting after college and had a 5D MkIII and then my current a7R III, photography was only a small part (20% or so) of my professional job doing design and web work. Nowadays it's mostly personal projects and lower resolution drone photos so my catalog isn't huge, and I've taken the time to massively cut down the repeats and slightly out of focus or blurry photos or just plain uninteresting or bad shots with poor composition from my catalog.
So today my entire catalog is about 2.5TB and I store it on two 4TB SSDs that I backup to each other now. I had hit the 2TB limit on my old Samsung T5, which I loved, many times and Samsung hadn't come out with a bigger drive so kept clearing storage on there hoping they would come out with something bigger. They didn't so I bit the bullet and got the Sandisk Extreme 4TB SSD last year and backed up to some old spinning drives, and then got the Samsung T7 Shield for only $199 recently since it came out this autumn, which is a great deal for a fast little rugged drive, and made it my primary since it runs cooler and is more efficient and it backs up to the SanDisk.
So if you're not a hardcore photographer, just a couple of these relatively inexpensive SSDs and Carbon Copy Cloner is all you need to do periodic backups. I've looked at NAS but it just seems like too much hassle and it's so slow and more prone to failure unless you get one that can do RAID 1 or RAID 5 or something. Eventually I would like to get another one to store in my security deposit box, and rotate it out quarterly. Or maybe I should get a small fireproof box to store it in my metal desk drawers.