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.
Archerfish has the credit for the largest warship kill by a submarine in history: the Japanese carrier Shinano, converted from the third Yamato hull.