Right, I googled Queen Mary and according to Wikipedia she is permanently moored at Long Beach California and serves as a tourist attraction (restaurants, etc) and a maritime museum.
Other than the above, I don't know. We have a Great Lakes freighter that has been turned into a museum. The Willis T. Boyer, sister ship to the Edmund Fitzgerald.