It doesn’t go without saying. I disagree about physical media. It’s one of the few ways to guarantee you actually own the thing you bought. People still buy brand new vinyl.

Technology rarely disappears completely, but it does usually fades into hobbyist and collector territory.

To answer the question, I don’t think SMS will be around much longer. It has many problems and is already being replaced by many different standards that are better in every way.