Primarily the YAF.NET membership providers give backwards compatibility to upgraded YAF.NET forums.
For most forums, this is not important. Otherwise, it supports YAF.NET specific features such as boards, better. Also, there are a couple optimizations which improve speed.
The ASP.NET providers work fine.