the reason why an atproto relay is so large in storage is because to validate (this is the authorized transfer part of the name AT Protocol) a record it has to know about all previous records by that account, so in effect it had to store the entire network on a relay, which is how you get these massive sizes.
that's what bsky is currently fixing, see this thread for more details https://bsky.app/profile/divy.zone/post/3liwwg45izs2r