Thanks for this question, it made me do some digging on the matter. From what I have gathered, the Security Council does not control any smart contracts that hold user funds. Even in a worst-case scenario where 9 out of 12 SC members are compromised, they cannot directly take users’ funds from the system.
The SC does have the power to push protocol upgrades bypassing any delays, meaning that a malicious SC could attempt to introduce an upgrade that alters key contracts. This is indeed a risk as you can see in L2beat’s Arbitrum review: Arbitrum One - L2BEAT
However, there are multiple deterrents for this to happen. The first one is the DAO itself, as it has ultimate governance authority and can intervene if a suspicious proposal is presented. Any contract upgrade is visible on-chain and it would follow a governance response. The SC is also deterred by public scrutiny, loss of reputation and backslash.
As a rollup, users can always withdraw funds back to Ethereum considering the bridge contract was not compromised. In an extreme case, a Fork can be done to restore any harm which would also make an attack less attractive for perpetrators.
In a PoA chain like XRP the same entities or validators (vetted by Ripple) control protocol rules and transactions, so they have full control of the network. In contrast, transaction validation in Arbitrum is independent from the SC.
A bigger risk for Arbitrum could arguably be the centralized sequencer which cannot take user funds but could halt the network if it fails. However, there is a roadmap in place and initiatives to further decentralize the sequencer and this: Team 8: Decentralized Sequencing .
“Arbitrum’s long-term vision includes transitioning from a centralized Sequencer to a decentralized, fair sequencing model. In this framework, a committee of servers (or validators) collectively determines transaction ordering, ensuring fairness, reducing the influence of any single party, and making it more resistant to manipulation.” Check: The Sequencer and Censorship Resistance | Arbitrum Docs
Also very interesting: Distributed Sequencer Technology — A Path Towards Decentralized Sequencing | by Figment Capital | Medium