Title: Version 2.9.7 - Subscription stays active when renewal payment is cancelled by bank
Description:
Since version 2.9.7 (August 2025), when a GoCardless SEPA payment is declined by the bank
after 5 days, the renewal order is set to "cancelled" but the subscription remains "active"
instead of being set to "on-hold".
The "Improved subscription cancellation" feature in 2.9.7 seems to cancel orders but doesn't
properly handle subscription status when payments are cancelled by the bank (not by customer).
Expected behavior: Subscription should be set to "on-hold" when payment fails
Actual behavior: Order is cancelled, subscription stays active