There used to be a lot of ships visiting Portland, Oregon during the Rose Festival, until 9/11 happened. Then it seemed to go way down. Don’t know what happened...
http://www.rosefestival.org/events/fleet/
Oddly, they don't visit San Francisco as much as they used to, either.
Back in the 1950s, as a Mean Wittle Kid, my family took me across the Bay Bridge, and on board the USS Missouri.
In the 1960s, my wife's family took her, as a Snotty Teenager, across the Bay Bridge and on board the I forget which ship(s) for Fleet Week.
Can't imaging what has happened since to change that.../S>
Could part of the reason have been that Mayor who liked to date Islamofascists or something? She was a regular problem child as I recall.