Modern “ship-busting missile” are due to be fitted to Royal Navy warships soon after successful trials last year.