ACA grad scheme or Council Finance Role

I am in the middle of two minds and need some help

I have 2 job offers. The first being with a top 10 firm in Audit (ACA) or I have another offer with a finance role within the council which is paying £6-8k extra. The council role I can do ACCA or CIMA. Which one should I go for? I just fear the stress I hear about ACA and dismissals which I can’t afford to go through. For context I also don’t get any right for exemptions for ACA but for ACCA and CIMA, I have around 7/8 exemptions.

What would you guys do if you was in my position?