If I cancel my card would that affect my Mettle+ subscription?

No, your Mettle+ subscription is set up using your account number and sort code, cancelling your card will not affect your subscription.