Is the idea then that apps will keep their regular database of content outside of Nostr?

That’s an interesting solution to the problem of niche apps. Just simply don’t put the data on Nostr at all. Just use Nostr for accounts and nothing else basically