I think a compromise would be to delete notes that receive no interaction or have a 30 day delete timer that resets every time the note receives interaction. I'm not a node operator but I'd bet 90% of their data is notes no one ever sees again.