Great question, thanks.

Minor clarification: the 2 hyperlinks listed at the bottom of the explanation didn't contain a notification about future deprecation of the SP (not that I could find, anyway).

That note is present on the page for sp_change_users_login at this location.

Rich