1K years sounds far-fetched, it seems just as possible the framework holding up the pinhole camera will fail before then.

The longest exposure photo is about 8 years, and it looks quite good.

https://www.cnn.com/style/article/can-eight-year-photo-intl-...