It reportedly devastated Queen Elizabeth when parliament scrapped the royal yacht in 1997. She allegedly shed a tear because she had so many great memories of her time on the boat. Currently, it is moored in Edinburgh and is available for tourists to visit (via Boat International).
HMS Britannia is a remnant of another era and hosted many royal honeymoons. Furthermore, the queen famously toured the Commonwealth on the ship. It had a crew of over 200 and they even slept in hammocks. Finally, parliament decided that the running costs were too high to keep.