New study shows royal women received extensive weapons training and ‘completely challenges traditional view’ they lived idle lives