Yeah you're probably right. Redis is really designed for smaller bits of data than most Nostr notes are.
I was thinking about the advantages of fast in-memory databases for ephemeral data. A memory DB designed for larger chunks of data might ultimately be better, but I don't know what that space looks like all that well.