I have about 10 years of data on my RPi4 and all the data is about 1.7gb, I'm using a 1 minute archive interval (total used on the card is about 6.4gb). I use mysql and it might be different with sqllite as there is a lot less overhead. Good SD cards are cheap now and there are other storage options as well. I stay after the replication logs however.
I was sftping the pages to an external web hosting site every 5 minutes. But installed Apache2 on the pi to serve it instead. Then used dynDNS on the router,
no-ip.com type. Created a subdomain
http://weather.duanek.name at my domain provider to redirect that url to the dynDNS and now serve it off the pi. My ISP blocks port 80 so I just used port 8888 and set my router to forward that port to port 80 on the pi.
I really only have neighbors looking at this. So this results in less traffic even though the traffic from the sftp'ed pages was trivial.