If the UPI mandate fails due to insufficient funds, your SIP installment will still be executed for that cycle, success of the order will depend on the balance in your ledger.
You will receive a notification about the failure and can manually add funds or ensure adequate balance for the next cycle.