If your device only has a low duty cycle (like, it wakes up every few minutes), the ESP32 (at least C3 and C6, probably S3 as well) can still be used. Just use their standby mode, they draw as little as 5 µA in standby.
Granted they're not as good as others in that the standby mode requires a full boot to wake up (which can last as long as about 500 ms), but if again it wakes up infrequently, that's still fine. If you were considering using an external power switch to power it down, then clearly you'd be in the same boat anyway. So no need for that. Just put them in standby. They can even retain some RAM in standby.
If you want something that wakes up much faster and don't require a reboot, then yes, forget about them. There are tons of candidates these days. If you want something with integrated RF supporting BLE, then one of the lowest power of all is the Ambiq Apollo 3 Blue. It's not even expensive at all. You can also consider the nRF52 series as well, very good. OnSemi RSL10/15. The STM32L4/L5/U5 are very low power too and pretty good but don't come with integrated RF. There is the STM32WB series, with integrated RF, but I have no experience with those. They're probably a good fit too.