One trick pony meaning that its designed to run one sketch (program). Does appear to be work arounds, as mentioned here and elsewhere, but not for the faint of heart.
I agree entirely with you regarding process being fundamental to quality, and have found some great sources that the uninitiated (me) can grasp. Grateful that there's good technical material too.
It will likely benefit from multi-tasking, but may benefit from offloading some processes to another chip. Having said that, I think it was Eben Upton that spoke about the advantage of having one core do the leg work of communications / network stuff, the other core for applications. There's a lot of noise about utilisation of the second core on the rp2040. Does appear to be a bit early to come to any authoritative assessment of core 2.
The Arduino Nano RP2040 Connect does have an ESP32 in addition to the RP2040. It is in the u-blox NINA-W102 WiFi/BLE module. Most Nano RP2040 Connect users will just leave the stock "NINA" firmware provided by Arduino on the ESP32, but you have the option of putting whatever you like on it.
OK. Thanks. I've already run a sketch for wifi AP, blink test and remote control from my smart phone - based on the WifiNINA library. Its "Web Server AP Mode" from DroneBotWorkshop. Arduino Nano RP2040 Connect - Arduino meets Raspberry PI
Worked without a hitch.
How would 'custom' ESP32 programming be done inside of the W102?