At first sight, may I ask if you’re using Advanced Certificate Manager for such deep-level sub-domain case? Universal SSL doesn’t cover that and you’d have to purchase ACM:
Below article is the source where you’ve went to cross-check and used as a reference?
This subdomain points to R2 bucket, so advanced certificates don’t apply in this case, as stated in the url you provided:
“Advanced certificates are not used with [Cloudflare Pages] nor [R2] due to [certificate prioritization]. Both Pages and R2 custom domains use Cloudflare for SaaS certificates.”
Rule logic and request data are correct, If I send same request, sometimes it works, sometimes it doesn’t.