The name suggests that this isn't something you should get excited about - but standard or not, you wouldn't want this missile landing outside your front door. They're standard because they're incredibly adaptable, and can be fired at almost any target whether in the sea, in the air, or on land.
The SM-2 variant of the missile is the Navy's first-choice defense weapon in surface-to-air scenarios, and shoots down anti-ship missiles. The SM-6 will also take care of the aircraft that fired them.