Keep everything, forever if you are a professional. The time and effort it took to schlep yourself and your gear out to the site, potentially have a location rented, talent on site etc… you should justify keeping the photos. Get a SATA bay or enclosure to read naked SATA drives and store them in antistatic bags / safe place. Use GoHardDrive to buy affordable 8TB drives (choose the 5 year warranty). I think you can get them for $80… should be enough to store many many shoots with.

If you want to go to the whole next level of non cloud base archiving nerd-ery check out LTO Tape.

Also I recommend the subreddit Datahoarders for some good convo about data systems.

I like this PSA for sure. haha.