My feeling is – if there is a mechitza already up for this purpose then, the women should indeed take the opportunity to dance b’simcha.
If the custom of the shul is for the women to not dance – and a woman feels the urge to cut loose, so to speak, she should go to a shul where it is the custom.