Sarah Champion has resigned as shadow women and equalities secretary and apologised for her "extremely poor choice of words" in a newspaper article about child abuse.