The SQLMembershipProvider is fairly old code (almost a decade since last update) as is most of the 4.8 framework. This code base is no longer updated and only security fixes are supplied.
for creating a salt, RNGCryptoServiceProvider perfectly fine. It should not be used for new code, or code you expect to migrate to .net core.