Multiple sources close to the show tell PEOPLE what was behind the Real Housewives stars' departures from the Peacock series