Yeah it was. Portions of the movie Operation Petticoat with Cary Grant and Tony Curtis were filmed with the Queenfish.
This happened in the 70s so probably not operation petticoat.
I am pretty sure the Queenfish ended up in Long Beach at the Naval Shipyard. You could still see some pink paint showing under the chipped and worn mixed paints used to cover it up. It appeared that she was being used to offload waste fuel/oil into and was just docked out of the way by the warehouses by the early 80’s when I saw her.