It works in the case of the Culture because of their extraordinary degree of self-awareness and anti-militarism; no member of the Culture could possibly lack cognizance of the significance of the names, wheras we, alas, live in somewhat less enlightened times. In the Culture it serves to emphasise the ugliness of their purpose, wheras if applied in our world could be all to easily misinterpreted as unvarnished militarism.
It is interesting to note the degree of anti-militarism in Japan. Though this may be taken to an extreme in the opposition to taking part in international peacekeeping missions, at the very least it means that Japan is very unlikely to be subject to escalating influence and dominance by the military as may be permitted in other countries due to general public apathy. However, I think this also means that any attempt to emphasise the inherent ugliness the the purpose of the military would be prima facie faced with extreme opposition, no matter the intent.
I'm reminded of Star Trek, where the Federation's focus on "peacekeeping and exploration" never stopped it from fitting even the most measly science vessels with phaser banks and maybe some photon torpedo launchers.
On the other hand, Japan is not really doing much fighting at all, and their military is even called the "Self-Defense Force." They can't get rid of their military-industrial complex because they already did and what they've got now is what they were left with at the end. It makes sense for Japan to try and make their people comfortable with the idea of coexisting with the SDF, since they will in fact have to coexist with the SDF indefinitely. It's not going anywhere, and it's not really doing anything particularly ugly just sitting there.
Contrast this to the way [The Culture][0] dealt with their ambivalence over having to tool up to fight a full-scale war (the Idiran War). They specifically designed their warships to be ugly, and gave them ship class names reflecting the ugliness of their roles (e.g. Gangster, Torturer, Psychopath, and Thug). While depicting your weapons as kawaii is very different from depicting them as heroic/inspiring, I think the Culture's lack of euphemism is the better way to go.
[0]: https://en.wikipedia.org/wiki/The_Culture