Yeah that does sound like a nightmare.
The UK direct-debit guarantee includes the provision that you must get a full and immediate refund on error, to prevent this sort of thing, and while I'm sure it doesn't always work as smoothly as you'd want, they are very commonly used and not a great source of complaints.
https://www.financial-ombudsman.org.uk/businesses/complaints...
That said, fuckups do still happen! https://www.theguardian.com/business/2022/dec/07/kent-family...
[0] https://www.forbes.com/sites/maggiemcgrath/2016/01/06/63-of-...