Born more than a century apart, one a Victorian pioneer, the other an American who died young, these female stars of photography aren’t an entirely satisfying mix – but Francesca Woodman’s thrilling images steal the show