Acknowledging agreement and understanding.
I'd focused on ICBMs as those are the most likely application of SpaceX-scale technology --- certainly Starship, but also Falcon.
That said, far smaller rockets from tactical (< 300 km) to theatre (< 3,500 km) can be and have been devastating. Some are used for precision strikes, and designs such as the US "flying ginsu" are tasked with killing a single individual or small group, others are intended for specific and limited targets --- command-and-control sites, individual ships, bunkers, or installations. Interestingly, it's the less sophisticated weapons which tend to be used as if not weapons of mass destruction, then weapons of mass terror. Russian dumb bombs have relatively low individual kill efficacy, but at scale threaten and intimidate entire cities and populations. Their inaccuracy and randomness are part of their terror effect.
I'm reminded that Adam Smith commented on this effect in Wealth of Nations, in one of only two passages which contain the word "invisible", this being the one in which it appears twice:
Regularity, order, and prompt obedience to command are qualities which, in modern armies, are of more importance towards determining the fate of battles than the dexterity and skill of the soldiers in the use of their arms. But the noise of firearms, the smoke, and the invisible death to which every man feels himself every moment exposed as soon as he comes within cannon-shot, and frequently a long time before the battle can be well said to be engaged, must render it very difficult to maintain any considerable degree of this regularity, order, and prompt obedience, even in the beginning of a modern battle. Regularity, order, and prompt obedience to command are qualities which, in modern armies, are of more importance towards determining the fate of battles than the dexterity and skill of the soldiers in the use of their arms. But the noise of firearms, the smoke, and the invisible death to which every man feels himself every moment exposed as soon as he comes within cannon-shot, and frequently a long time before the battle can be well said to be engaged, must render it very difficult to maintain any considerable degree of this regularity, order, and prompt obedience, even in the beginning of a modern battle.
<https://en.wikisource.org/wiki/The_Wealth_of_Nations/Book_V/...>
And those short- and intermediate-range missiles do seem to be gaining in spread and use, along with aerial and sea-based drones. The idiots are gaining access.