(Much) more dead than habitable worlds is normal in this game, depending on game settings as GalCivius stated.
To be shot down by pirates is quite unlucky though, that didn't happen to me that early in the game yet. But you can avoid that by moving one tile after the other since the sensor range of a colony ship is bigger than the movement ability of pirate ships.