Best known for her giant spider sculptures, the artist explored patriarchy, motherhood and what it meant for women to be subjects rather than objects of art. A major exhibition at Bilbao’s Guggenheim reveals the power of her Cells series