This has to be one of the most practical applications of amateur radio. Keep in mind that all of these comms are unencrypted and are visible by anyone who has the ability to receive.
Some areas have one that works in reverse, taking what is seen on the internet and relevant to the active stations in the area and broadcasting it out over radio.
When I started using SMSGTE I had great success getting a SMS from my radio to a phone, but only 1 in 10 replies from SMS made it back to my radio. I put up a gateway for my area and so we have some decent bi-directional coverage.
This video explains a raspberry pi setup with Dire Wolf (software TNC): https://m.youtube.com/watch?v=YqTpyPLtjUA
Aprx works for me, Direwolf seems pretty popular. There are many different ways.