I profoundly disagree.
The game has always been about leaders, a much more vague and open-ended category, rather than formal rulers, so limiting selection to formal rulership is a change from the nature of the game. From the very first game, there have been leader(s) who were not head of state or government. Indeed, the mascot of the series never was a formal ruler (Gandhi).
The attempts to narrow down from leader to ruler are, to my mind, a fundamental simulationist misunderstanding about the nature of the game. Civ has never been about precise and accurate representation in all details of historical groups. It is a game of wild what ifs such as "what if Alexander and Abe Lincoln fought a world war against Genghis Khan and Gandhi,", "what id Samurai fought Hoplites" and so forth. The civilizations are not meant to be accurate depictions
As to France, regents still wielded formal power as effective head of government/states. They did not inherit or transfer the line of succession, but they ruled nonetheless. Erasing the many women who served as regents in French history (including CDM) is defacing French history and making Sallic law far, FAR worse than it actually was (it limited inheriting the crown, not wielding of state power). "Men have always had an absolute monopoly on state power" is a downright lie as far as French history is concerned.
Far from an accurate depiction of historical sexism, rejecting women leaders for France would be an accurate depiction of modern simplistic assumptions from popular pseudo-history and lack of nuance.
And that's the problem with "we need to represent historical sexism as it was". It often ends up with exaggeration or ignorance of the actual sexism's actual limitations, focusing only on superficial understanding of monarch lists while gleefully ignoring critical nuances in their hurry to present the past as a bad place.