The hard-won visions of women artists reverberate in a Tate St Ives exhibition inspired by the writer's work