Yes, there are trail cameras with WiFi or 4G connectivity, but the good ones are expensive. The Chinese ones are often a pain.

I had one with 3G, it wasn’t reliable. I had a Moultrie one that was nice, but like yours, only SD card.