If you really want, there are devices you can install to do this yourself and self-host the infra for (minus the mobile data), not sure how well they work with fancy modern cars, but they exist.

example: https://vandogtraveller.com/cheap-gps-tracker-installation-a...

obviously it would depend which product you pick to define the interface (SMS is not ideal, fair enough) and capabilities