Deborah HaNeviah is clearly THE exception- that’s why the Gemara discusses her shoftus at length and is perplexed by it.
Pretending that women’s roles and occupations haven’t changed is to live in ignorance. Women working away from home, especially in high-powered jobs has been on the rise for 50 years. Women earn advanced degrees, and sit on the boards of fortune 500 companies. Even 60 years ago, this was unheard of; mah she’ein kein regarding the times of the gemara!!!
Because back then, women weren’t expected or allowed to hold jobs of influence or power over a community. They cared for the home and raised children- and this remained the status quo for thousands of years.
Halacha is often shaped just as much by societal norms and trends as it is by objective moral standards. Good examples are cholov yisroel, which rav moshe held wasn’t necessary because times and countries had changed. Ditto for certain laws of tznius, since they vary widely by county. In Europe it’s standard to kiss a woman on both cheeks upon meeting her- in America that’s unheard of. I could go on and on- different rabbanim had different attitudes towards relations with goyim based on their OWN relations with goyim, based on their respective cultures and societies.
All I’m saying is that Halacha was always getting rescaled and evolving based on what happened at certain times. In this case of rabbahs, we have to think about whether this is a positive change, similar to the increasing of Torah education for women in the last century, or negative, like intermarriage or eating treif by the non-frum.