Since you ask me: a CEO is the public representative of the company. It's also their job to shape the company's directions and values.
I am an atheist, but I am okay with theistic CEOs as long as they don't try to shape the company's value to be theistic. I do have a problem if CEO wants company-wide religious ceremony.
If the position is to be against someone-who-would-fund-blah as a CEO, but okay as a colleague, this doesn't seem to help depriving the campaign blah from being funded (as long as someone didn't plan to increase donation from increased remuneration as a CEO). If the position is to be against someone-who-would-fund-blah both as a CEO and a colleague, I am not sure I support that position.
The main point being, while setting company-wide policy is greatly helped by being CEO, funding campaigns is less so.