ESP32 has inherent sleep issues and before their latest chip (c6 I think) 'deep sleep' was really a gpio- or rtc- triggered boot followed by a power off. Doesn't mean it's impossible to implement wifi sleep efficiently, but if you do the math anything wifi based won't work off cr2032 for even a year unless daily updates is all you need. Motion sensors are supposed to fire more often, and with much less latency that can be done via WiFi, so it doesn't really work for battery powered sensors in the general case. You could probably use ESPNow and a custom gateway node but at that point it's just another custom RF protocol and you're better off with something standard like 802.15.4 or BLE..