Eight crewed warships are due to be retired by 2031 - including three mine-hunting Offshore Support Vessels (OSVs).