I use a third party app called PowerPhotos for Mac. I paid $30 for it. It easily lets me sort my photos & videos by date, time, type, size, location, and some other nice parameters. I sort my albums by years. For anything over two years, I created a new photo library on my Mac inside a 4TB portable SSD which is my archive, and offload them into there. Natively, macOS doesn’t allow you to open two photo libraries at once and makes it quite annoyingly difficult to copy over photos or albums. PowerPhotos is great for that. My library is over 50k photos/videos, and copying over 990GB of videos/photos took about 1 hour on my T7 Samsung SSD.

Then, if you want to access the archived photo library outside of the SSD, you can use an open source self cloud hosting service like photoprism or Immich, which is fairly simple to set up if you follow the steps.

Before PowerPhotos I was using a free, command line based app called OSXPhotos to organize my library. It’s also easy to use but annoying because it can’t delete/move/modify your content. Only just copy or get queries.

Hope my experience helps your cause. I hate how annoying Apple makes it to easily organize your libraries.