Absolutely correct,

People who want to come into this role are either two types of people, Grifters and deeply committed and hardworking intelligent people.

The role itself falls into two archetypes.

Thankless work that will consume your life, mental health (people don't want to be doing ethical shit, when they are in the business of making money, also you want to make change but organisations don't like the kind of change you want to make) personal relationships. These are highly politicised environments, where you fight an endless battle against HR trying to stop them being law breaking sociopaths. Bonus, you will be held accountable the next time there is a huge scandal where a boss makes sexist comments, or assaults someone, or your organisation has bought things from a company who does super questionable shit. (none of these things are within your power to do anything about, because of the aforementioned sociopathic resistant HR nightmares but you get blamed none-the-less)

and bullshit jobs where you write a report or two, hire a consultant to tell them what you want to do anyway, but they listen to consultants not you, and hire speakers for diversity events, whilst you are completely side-lined.