All the content for Shivering Isles is in the Oblivion.esm. The DLCShiveringIsles.esp is only there to load the BSA files (a trick they gave Oblivion for the DLCs).
If you want to make mods that aren't dependent on Shivering Isles there are two ways: Use the Oblivion.esm for SI, but just don't use any of the SI assets and it should work.
Or, install Oblivion but don't yet install SI, but do install the 1.1 patch. Copy Oblivion.esm file and rename it to Oblivion_1.1.esm. Install Shivering Isles and the 1.2.0416 patch if necessary. Then you can use Wrye Bash to swap back and forth between the two versions of Oblivion.esm as you work.
Basically the .esp arranges all the rocks, all the monster, all the trees, terraforms the land, creates an alternate worldspace, creates hundreds of NPCs, and so forth that are all dependant on what is in the master .esm.
Actually, in this case it doesn't. DLCShiveringIsles.esp is almost completely blank. Some people actually rename the Unofficial Oblivion Patch to DLCShiveringIsles.esp in order to gain an extra mod slot. This doesn't affect the playing of the game at all.