As Subliminal Aura says, unified, centralised library is the main advantage.
Also, if you're using lower powered clients, such as a Raspberry Pi, the relatively "heavy" database work is offloaded to another machine, leaving more processing power for the Pi to actually run XBMC, which can mean it runs quicker.