But the RP2040 has no non-volatile storage, right? So you need to include a Flash chip in your cost estimates.
It'll still be <$2, but it also means putting another chip on your board and routing around it. The old ESP32s worked that way too, but most people used the SoM "cans" when those chips were new because of the complexity in routing an antenna trace.
Personally, I'll wait for gen2 and pray for a simpler bootstrapping process for bare metal code.