Battleship Becomes Museum: what are the possibilities?

In the long tradition of ship museums the US battleship Iowa is to become a museum in Los Angeles.

The UK has many warship museums (HMS Victory, Mary Rose, Warrior, Belfast). The Iowa, although even older than me, was still an operating warship until relatively recently. Controversy has inevitably followed "a peace-loving city was no place for a battleship."

Read more: http://www.sfgate.com/cgi-bin/article.cgi?f=/c/a/2011/09/07/MNNJ1L1F7R.DTL#ixzz1XXhojwG7
This begs the question, should the battleship go to a war-loving city? This obviously narrows the field slightly. Most city authorities actually try and promote safety along with their cultural offerings. The idea of 'safe' heritage is perhaps a topic for a future blog. However, back to the problem at hand, where is the ideal place for a battleship?

A war-loving city near the sea? How about Mogadishu? Its on the coast and probably needs a boost to its tourist economy and culturally there are thin pickings there. The business plan clearly cannot rely on tourism to fund it, the tourist economy can grow (well it cannot get any smaller), so the battleship needs to earn its keep in some other way.

Somalia has a little local difficulty with pirates so there are two options.
1. The battleship can have a practical use against local pirates. Much bigger guns should make it a one-sided contest
2. The battleship can have a practical use for local pirates. Much bigger guns and greater range will make them much more effective.

Which will generate more income? Defeating pirates and increasing tourism? Or encouraging piracy and encourage a culture of philanthropy from newly wealthy pirate entrepreneurs?

I don't have the answer, but look out for the privately funded National Museum of Piracy coming to a war-loving city nowhere near you (if you're lucky).