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.
The wiki says she was sunk as a target in 1963. The second Queenfish (Sturgeon class) was scrapped in the 90’s in Bremerton.
The wiki says that the pink scenes were the USS Balao. The USS Archerfish for the scenes in standard gray and black, and the Queenfish was only in the opening and closing scenes.