[R] Enable full feature libarrow build as default on macOS

[assignUser]

Describe the enhancement requested

With the new build system added in #37923 the default macOS source build does not build with gcs/s3 (even if openssl and libcurl are available).

• update r/configure/nixlibs.R and r/tools/build_arrow_static.sh to build as many features as possible on macos
• take rosetta into account (no jemalloc see install-arrow.R)

Component(s)

R

[jonkeane]

This is a definite blocker for 14.0.0 yeah?

[raulcd]

I was going to treat it as a blocker due to the label.

[paleolimbot]

Unless we've changed direction, I think we're planning on submitting the release to CRAN with the "static downloading" approach (and only use this approach if we are asked to do so by CRAN). Under that logic, I think we can remove the Blocker status of this issue (but only if @assignUser confirms this!).

[assignUser]

Eh, as the PR is basically done I'd prefer to get it merged... Just to be sure ^^

[paleolimbot]

OK! (As long as we are not rushing the PR or holding up the release unnecessarily)