As noted, Paul Heyman has been removed as the head of creative for WWE RAW and is no longer the Executive Director of the red brand. WWE is consolidating the RAW and SmackDown creative teams into one group, to be led by Bruce Prichard. You can read the original report with WWE's statement at this link, and you can find backstage updates on the story here, and here.
Sports Illustrated reportedly contacted 10 different active RAW Superstars and each noted that Heyman's greatest strength was the guidance, recommendation and direction that he provided to the talent.
WWE confirmed that Heyman will remain in his role as an on-air talent with Brock Lesnar, but there's no word on if he will be present for the weekly TV tapings as Lesnar isn't used regularly. SI noted that every WWE talent that they contacted also shared the hope that Heyman will still be at TV each week to critique their work.
SI also noted that there was not one specific incident that led to Vince McMahon deciding on Heyman's departure, but a difference in philosophy that was magnified with the two working together so closely since Heyman was promoted to the role last year. It was described as a situation where the Heyman-McMahon working relationship reached its expiration date. Furthermore, Prichard is able to present ideas to Vince better than anyone else in creative. While Heyman may have the better idea of what fans want to see, Prichard understands Vince and how creative ideas need to be pitched to him.
Stay tuned for more on the latest WWE creative shake-up.