DEPR offsets: rename 'SM' to 'SME'
xref #52064

Deprecated the alias denoting semi month end frequency ’SM’ for offsets in favour of ‘SME'
@MarcoGorelli, could you please take a look at this PR? I think ci failures are unrelated to my changes.