Meta's second most powerful executive Sheryl Sandberg made the shock announcement Wednesday she will leave after a 14-year tenure that included helping steer scandal-prone Facebook to advertising dominance.