Yes, .NET Standard is the ideal target. I'd consider this change to .NET Core a stepping stone towards that, since, as far as I am aware, .NET Core is the "closest" to the bare standard.
Some work to ensure SFML can function correctly while using no more than .NET Standard (and make the necessary changes, if any) will need to be done (as was done for .NET Core).