Considering what we saw on Covenant he only had enough to bomb a city. He might aim for Weyland's house or the Company's main building. It wouldn't be as bad as Alien infestation, the space pathogooze would just kill all humans in the area, it wouldn't generate alien creatures, then if the government quarantined the area, there wouldn't be hosts for the neomorphs sacks, which who knows how long it takes to form those. The rest of Earth would probably be fine.
Unlike those stone age Engineer wannabes, Earth might use its defenses against an unknown spaceship entering it without warning.