Agreed.
The thing is, in this battle the militia ase supposed to represent massed volunteers, more than 10000 versus de 5000 strong French army. This does make it kind of un-winnable for the French (and maybe more historical because of that).
I have playtested vs myself a few times, and the French do run out of options as soon as they take significant losses. I think the answer would be to remove about seven of the Spanish MI, but what I wanted was for the town hexes to feel terribly inhospitable for the French player (in reality there was vicious combat in the streets, with people attacking and throwing all kinds of objects at the French from windows etc). This effect could be represented by making the French roll one die to see if they take a hit (XSW wouldn't count, but flags maybe should). I guess what I'm getting at is, in a nutshell, trying to reproduce urban (assymetrical) warfare in CCN.
As for the composition of the French force, it is intendedly not ideal for a city fight (only one ART but many CAV) because of historical circumstances.
If you think the above idea could fix the issues and the scenario is worth it, I will gladly patch it up and upload it here
Thanks for the input!