The theory that history is defined by alpha males feels unfashionable and offensive – but Ridley Scott's Napoleon proves we can’t let it go