There have been multiple similar proposals to make her an attraction like the Queen Mary in Long Beach, but none ever attracted enough funds and support. She certainly couldn't be a modern cruise ship without a very expensive rebuild that would destroy her character.

While she is a famous ship, she wasn't really an important ship. Yes, an impressive technological showpiece, and many people have memories of sailing her, but she was also essentially the last of her kind, built in an era when her usefulness was ending. She never served as a troopship, and has lingered on for decades as a pier queen.

Unless someone with lots of money steps up with a plan and a place to put her, this will be a useful purpose. She'll be remembered through the images of her in her prime.