Rodman's signing ends a prolonged NWSL saga and keeps the U.S. women's national team star in the nation's capital