That stops the payment from happening. But it does not stop your contractual obligation to pay.
So it really depends on the business and how much information they have about you, and if they are dirty enough to send you to collections for it.
A gym is likely going to send you to collections. An online SaaS is more likely to just cut you off and cancel the account.