Can I use RStudio Package Manager in an offline, air-gapped environment?

Yes, there are is detailed setup, process, and configuration information available in the Air-Gapped RStudio Package Manager documentation.