Gold on a grey day as Navy’s oldest active vessel sails into harbour for the last time