Notion, recently published a blog saying they have 200 Billion blocks stored in their postgres instances with hundreds of terabytes stored.

My guess is that the average user does not care/think about privacy, breaches etc. that much.