From: The Great White North!
Dance of the Vampires chapter in RSR.(
I cannot remember where, but there were some very interesting threads here a couple years ago which discussed roles, loadouts and tasks for VLS ships. There was some documentation with some very informative charts.
Scenario designers should realize that the loadout in the CMO DB is simply a baseline starting point. Each TG in RL is configured based on a detailed assessment of the threats and tasks expected. Why would you carry TLAMs if you didn't have an ASuW task? If the bad guy your facing doesn't have BMs, why do you need ABMs? How strong is the Sub threat - how many ASROCs do you need... etc
No ship or TG will completely strip itself of a capability, so even if you don't expect a threat, there will still be missiles to counter it - but the choice is in the weighting.
E.g. You have a CSG going into the Western Pacific - air threat high, BM threat high, CM threat high, Sub threat high, chance of an ASuW task coming your way probably low. You're CSG has 1x CG-52 and 3x DDG-51. You need to mix and match your ~400 VLS tubes to counter the threat. The real loadouts are highly classified, and the number of certain types of missiles limited, they can only be reloaded in port so length of the mission is important. So I think that the balancing of these factors when setting up a scenario is important.
So sure, you can load them up with a heck of a lot of ESSMs, but they don't work so well against subs or BMs and will be overwhelmed quickly by CMs if the strike hasn't been whittled down a bit.
This is part of the fun.