Todjaeger
Potstirrer
I would argue that yes, it would be worse, because the arsenal ship would be essentially unable to defend itself (unless it was fitted with the appropriate systems like are found aboard a DDG) and would likely not even be aware that it was being targeted or engaged until it was too late. If the USN to operate a 500-cell arsenal ship within striking range of mainland China, the PRC would become aware of that fact. I would then expect them to make finding it a priority, and following that, finding a way to neutralize it before the missiles in the VLS cells could be launched. In order to prevent that, the USN would need to embed arsenal ships into CSG's to protect them vs. aerial, surface and undersea threats. I frankly think the cost too high, and potential strike value too little for it to really be considered worthwhile.Would it be any worse than losing a $2B DDG?
Assuming each cell costs $2M to fill, on average, and an arsenal ship costs $1B to build.
1 x DDG costing $2B + 96 VLS cells at $2M each = $2.2B
1 x Arsenal ship costing $1B + 512 VLS cells = $2B
The DDG can defend itself, for sure, but maybe carries 1/10th the offensive firepower.
How long it takes to manufacture 500 missiles is entirely dependent on the missile build rate. If we want to build more, we invest in larger/more factories. At the height of TACTOM production, we build 496 missiles in a year (2008), but there's no fundamental reason we couldn't build ten times that many per year, if we wanted to.
If the USN really did wish to increase it's potential strike capability and add a conventional strike deterrent, then I believe that modifying some of the plans for the upcoming Columbia-class SSBN to make a SSGN variant, like was done with four of the Ohio-class subs, would be the way to go. The PRC would likely be able to tell where the USN had such subs based, and might be able to keep track of when they were in port, but once underway out at sea...
The VLS cell count would likely be quite a bit lower than a concept arsenal ship, but being a sub would be much less vulnerable when deployed to air and surface threats, and honestly would likely be better kitted out to evade or engage underwater threats.
Otherwise the only way I can really think of an arsenal ship being valuable would be if the vessel was disguised like a q-ship, if that is something that could even be done today.