For modern macOS (Ventura/Sonoma/Sequoia): The Alfa N Pico will not work. You need a chipset with native macOS support (like RTL8812AU with community drivers, which is still buggy). For Mac users, your best bet is to run the Alfa inside a Windows 11 VM (Parallels/VMware Fusion) and pass the USB device through.
Ultimate Guide to the Alfa Wireless N Pico USB Adapter AWUS036NHR / 3001N Driver
: 2.4 GHz only (does not support 5 GHz networks). Standards Compliance : IEEE 802.11n, 802.11g, and 802.11b.