All that's left to do after the download is complete is to open your brushes pallete, click the arrow for the drop-down box to appear, and chose either load or replace brushes. Click on the set you want to load, and that should be it.

The only other explanation I can think of is that your version of Photoshop may not be compatible with the CS brushes.