Can only say for my 2016 Premium system but there is no option to locally delete SMS.
One can toggle automatic transfer from the phone though, so perhaps toggle this off (if applicable to your system/year), presumably only new SMS, received whilst connected, will be available in the car system?