Where does Mac Messages store older Attachments?
After comments
It does appear that these are shuffled off to iCloud, whether you want them to be or not.
From the Details button, top right, then scroll right down - rather blurred picture to demonstrate

Clicking that Download restores them to their correct location. How long before it decides to remove them again I've yet to discover.