It is realistic for Celtic and Germanic women to have accompanied the men to battle, the only thing that was silly about the screeching women was the name.
But they tended form a mass on non-combatants behind the battle line, not formal units.