An all-female leadership team on 'Turning Red' made it easier for Pixar creatives to share 'embarrassing period stories' to brainstorm its coming-of-age movie