Resubscribe process isn't possible after payment failure

[timur27]

Describe the bug

The resubscription feature prevents shoppers from paying for a re-subscription if a previous payment failed.

To Reproduce

1. Purchase a subscription
2. Cancel it so that the resubscribing possibility is now available
3. On the My account -> Subscriptions page, go to the subscription's details and click the Resubscribe button
4. On the checkout page, use a declined card number so that the payment fails (e.g. 4000000000000002)
5. After the checkout is failed due to the card being declined, go to the subscription details page in My account
6. Confirm that there's no possibility for you as a shopper to re-attempt the payment
7. Confirm that you didn't receive any email with a link to pay for the previously failed transaction

   Product impact

• [ ] Does this issue affect WooCommerce Subscriptions? yes
• [ ] Does this issue affect WooCommerce Payments? yes

Additional context

Here's the initial discussion p1693315909474859-slack-C7U3Y3VMY