My idea was to serve it in a way that would allow ActivityPub clients to resolve content still, while having a light static render for other clients for local content.

For content on other instances it would probably require some kind of lightweight redirection service towards the original item to be set up to prevent breaking those URLs.

This could probably be built just from scraping, without requiring database access.