Synths and routing can defintely be confusing at first.
The main reason most of us don't recommend using the MS Wavetable synth is that is is somewhat of an anomaly.
It is technically a softsynth, but it is seen as an external hardware synth by Sonar (SHS7).
It operates outside the Sonar environment, and its audio output follows a different path.
This is why it is difficult to get it to export properly, and getting it to do so can cause problems with the rest of your project.
"But the different maps don't all make the same sounds in the same positions." This is true, and Kalle has touched on that.
The different maps redirect the notes to different drum sounds. Most of the hardware devices listed, such as the Alesis DM5 Acid Kit, are not mapped to GM, so the drum sounds that get triggered may or may not be what they claim to be when using the MS Synth. it is merely interpreting the data the best it can.
Try this:
Insert TTS-1(this is a General MIDI synth included with SHS7)
Select:
First Synth Audio Output
Synth Properties Page
Now, change the output of your MIDI drum track to TTS-1.
Set the Channel to 10 (not absolutely necessary, but follows convention)
Set the Bank to 15360-Preset Rhythm (this one is important)
Click on the Patch button.
You will see a handfull of Named patches, and many with just numbers.
Select one of the Named patches. The numbered ones contain no data and will drop back to something TTS-1 can identify.
Play the one you have selected ( I like the Power Set myself).
Now, select a different named patch, and play again.
Do you hear a difference?
If you open the PRV, you will see that these sets are mapped for you.
The major benefit is that TTS-1 is a soft synth operating within the SHS envirnment, and exporting is much easier.
Sorry for being so wordy, but I know how confusing this stuff can be when you are starting out.
You might also like Session Drummer 2. It's a $10 download, and a fairly decent drum synth.
There is also a preset drum map for it.