It works.
I connect to my home Windows Library with my MacBook and my Mini all the time. One thing to mention, is that since the path will never match, it means they always rely on the server streaming the files to them, and can't read the files directly like a Windows client on a LAN with a mapped drive does. So functions like Locate on Disk (External) don't work.
But... That's not a huge deal if you just want to listen to music. Try the free trial. Don't buy before you're sure it'll work for your needs.