HR leaders tend to be hired as partners in workforce transformations, but are most often the ones to suffer the consequences if such efforts fail, a new report said.