The RP2040 doesn't have a good low power sleep mode. It uses several hundred uA in sleep and dormant mode versus the ESP8266 which uses only 20uA in deep sleep.

This makes a huge difference for sensor systems etc. A pico/RP2040 cannot be powered by a battery for very long.