My understanding, is that it went back to Shakespeare. In Ye Olde Days, women weren't allowed to act. Men dressed in drag to play the parts of women, and used those shrill voices.

As it was, I think Connie Booth was the only proper lady that showed up in Python stuff.