I was also perplexed about the point of the RP2040 in general until I actually tried it. It's cheap, it's actually available, it's plenty powerful for many applications, it's amazingly overclockable - it runs reliably at up to 400 MHz or so, the PIO is great, the support is good and the documentation as well. The C SDK is also reasonably good and not too bloated. Compare that to many "similar" (but that won't even come close for a number of the above points) cheap chinese MCUs.
The Pico dev boards themselves are cool for hobbyists or people willing to prototype a solution around it. The W version, why not? The RF SoC they picked is good and also well documented (at least compared to some other, more obscure chinese solutions). It makes the board a definite alternative to those ubiquitous ESP32 boards for many applications.
Just a thought. In any case, use whatever fits your bill, you're comfortable with and that is uh... available? Having more choice here is a good thing.