Does this retry feature apply to all Direct Debits and scheduled payments?

Yes, it applies to all Direct Debits and scheduled payments that fail as a result of not having enough cleared money in your account at the time of the first attempt.