Intermediate tyre gamble was ‘worth taking but it didn't pay off’, says Horner