Chief executive officers for public and private companies aren't particularly satisfied with the business acumen of their general counsels, according to a new report.