Their partners already have tons of alternative boards ready to go, including a few which are drop-in replacements for the Pico, if you don't mind spending a bit more for USB-C:
The problem is most of the boards from partners are specialized with different hardware add-ons and have a significant markup at about 10 USD a board, which makes it harder to justify buying a handful of boards to tinker with. It's quite unfortunate.
No, these are microcontrollers. They're the thing you'd put inside a device that needs a tiny bit of smarts, like Raspberry Pi's debug probe[0]. The case I have for my RPi5[1] uses an rp2040 to run the thermal management logic.
https://www.raspberrypi.com/for-industry/powered-by/product-...