If the target creature you control is an illegal target as Self-Destruct tries to resolve, the creature you control won't deal damage. If the creature you control is a legal target but the other target isn't, your creature will still deal damage to itself.