It does work, but there are caveats:
1) RMS can interfere with or otherwise cause wierdness with SPS search indexing
2) WSS/SPS 2003 have no integration with RMS, so rights are only enforced by the
client application that is actually used to open the document (e.g. Office)