I haven't tried anything like it, but I'd be somewhat interested in hearing how that turns out. Lemmy does a fair bit of DB reads/writes, and I don't think the throughput of the average SD card is up to the task if you subscribe to a lot of things or get a number of users.
But I'm totally open to being wrong.