r: Publish R binary packages for releases?

### What feature or improvement would you like to see?

For R wrappers around drivers, it may be nice to publish binaries for the packages that aren't on CRAN (currently: Snowflake, FlightSQL). I think we can probably get those two drivers on CRAN at some point; however, future drivers might be more difficult to wrap (e.g., if they use C++ that is impractical to wrap without CMake).

It should also be said that there's a workaround for all ADBC drivers thanks to it's design! (One can install the `.so/.dll/.dylib` and point to that from the driver manager).

@jeroen has kindly provided https://github.com/r-universe-org/apache.r-universe.dev as a temporary solution for building Arrow R package binaries (on Mac + Windows), although as the repo states, it should really be moved into/be supported by the apache organization if we're going to use it for any sort of official distribution.

Start by reviewing the R wrappers for the Snowflake and FlightSQL drivers and the temporary apache.r-universe.dev setup mentioned in the issue. Compare that approach with CRAN and the existing driver-manager workaround; done means agreeing on an official, maintainable distribution path for binaries, including how future drivers would be handled.

Written by the indexing model from the issue text.