There are boards with the ESP32 and the SIM800 modem for about 15 €,
but I think the ESP8266 and a SIM module for about 3 € are better, the ESP32 needs a lot of energy.
There are good SIM cards to buy in Germany, at Telekom 500MB cost 12€, at Vodafone 1.5GB 15€, the cards and the credit are valid for 10 years!!! (0,13€/
month)
The cards are valid worldwide roming. Since M2M IoT cards are almost always valid worldwide, there are definitely other sources of supply all over the world.
My GPS data logger sends every 3 minutes, it needs a maximum of 3MB / month,
There are cards for a special energy-saving protocol, but that needs special modem modules, so I prefer the old 2G variant, because SIM800 (L) SIM900 also work, dial-in and data is sent like a serial modem,
Now it is obvious to send MQTT, your solution works perfectly via wifi, but now it would have to be packed into the serial data string,
do you have any ideas, does it sound interesting to you?