arrow

GH-44114: [R] Add Rocky and opensuse to the allowlist for libarrow binaries (#44124)

### Rationale for this change

Add two distros not checked on CRAN to our allow list for easier binary
installs

### What changes are included in this PR?

Added to distro names

### Are these changes tested?

These configurations are tested elsewhere, the real test will come later
if CRAN somehow runs these covertly

### Are there any user-facing changes?

Faster, more reliably installs without intervention
* GitHub Issue: #44114

---------

Co-authored-by: eitsupi <50911393+eitsupi@users.noreply.github.com>