Do I need to enable Real-Time Bank Balances on all bank accounts for embedded banking?

No, when you subscribe to the services, the bank lets you select which accounts you want to enable for real-time bank balances.