If you wrote your code in Circuit Python you can make the esp32-cam connected to a wifi hotspot and transfer...  via http or mqtt as you whish.
But if you manage to get a picture from the camera WITH circuit python then you need to share how you achieved that!
Newbie alert
I have code that takes a picture with the camera on the ESP32 but then that picture is in the flash memory and I don't know how to retrieve it. How do I get it onto my computer using micropython or circuitpython?
Micropython/Circuitpython - ESP32-Cam - How to download images taken onto computer?