As the other commentators have pointed out - your copyrighted song is copyrighted (assuming you didn't use anyone else's creative commons sound in it); this sound however is still licensed under a creative commons sample+ licence. This might seem unfair, but think of it this way. If you could retract a licence, then no one would ever be safe using a creative commons sound or public domain sound. Since there would be a commercial incentive to 'release' sounds into the public for free, and and seek out money from those who had used them honestly.
Unless you are able to delete every copy of the sound that was distributed under the Creative Commons license it would be impossible to revoke the license. You are free to use the sound within a song that is protected by copyright, but that does not change the copyright status of the sound. Since you gave others permission to use the sound when you originally distributed it on this site, anyone who downloads it also may use the sound in any music of their own that will be protected by copyright, as long as the persons using the sound give you attribution according to the license under which you distributed the sound.