I assume the backup is the copy in R2.

That's better than nothing. Personally, I wouldn't consider it archival storage, so much as the possibility that 20 years from now Cloudflare (or a holding company) pays me $100 compensation for my lost data!