Yes. That is what happened to me in my past life in my lifetime. No reincarnation.
Unless you want to tell me who was I before I was born. Being curious and all.
Can't do that, at least not reliably. There are past life indicators in a natal chart, but they don't necessarily tell us who you were in previous lifetimes (assuming previous lifetimes exist--not everyone would assume that). The south node, its ruler (Pisces has two rulers to consider, Neptune as the modern ruler and Jupiter as the traditional one), and any aspects involving the node or ruler, give us the outline for a past life story. Take some creative license with those, and we can come up with a plausible story of who you might have been and what happened to the past version(s) of you that's left for you to work out in this life.
I used to read charts a lot for that, and found that if I came up with the right past life story, it bore a strong resemblance to the native's current life--at least to the earlier part of their current life. By the time people reach their late thirties to early forties, their life story usually has more of the north node in it, but earlier, it looks more south node. There might be hints of the north node in your life when you're younger, but typically, you're still living out a lot of south node stuff.
And to complicate things, lots of charts have some mingling of north and south node indicators: the ruler of one node with the opposite one, for instance. You have Jupiter in the same house as your north node, which connects it to both where you're coming from (south node ruler) and where you're going to (with the north node).
All of that is to say, your current life story is enough to tell us what your nodes are telling you. Everything you shared--the isolation, the abuse, the being kept out of the world--matches your south node indications.
Simply put, south node in Pisces indicates being removed from the world in some way. North node in Virgo indicates a need to come back into the world. Second house south node adds some more detail: security, issues around security, were a big part of the picture. Often, a second house south node indicates a past of either extreme poverty or extreme wealth. Whether you were poor (I would guess that you were, since rich kids don't often land in the foster system) or rich, money, who has it, who doesn't, who controls it, what you (or your parents) have to do for it... that's a big part of the picture.
One ruler of your south node is in the twelfth house, the other in the eighth. Those are the secretive houses. The most negative interpretations of those houses (when we're looking for problems associated with the south node, we look for negative meanings of the placements), are some of the worst possible things: death, abuse, particularly sexual or psychological abuse (eighth house); isolation, addiction, illness, particularly mental illness, dissociative states (twelfth house; Pisces also has those associations).
Those houses are also, if we look for the positive meanings, very rich. Eighth house in particular (which I want to focus on here because you not only have your north node in the eighth, you also have your sun and a stellium there) holds a lot of power. You're an eighth house Leo: you need to claim your own power. North node in Virgo in the eighth tells you how: you need to come back into the world. Establish routines. Take care of your health.
I would also associate alternative healing methods--things like hypnosis and herbal medicine and shamanic cures and traditional practices (every culture has its own traditional medicine, involving various forms of ritual and usually herbs)--with the eighth house. If you know, or can discover, anything about traditional healing in whatever culture you or your ancestors came from--or, barring that, simply whatever of those methods are available to you--that might be a great help.
Back (sort of) to your original question: seventh house isn't just what you need from a partner, it's also what you need from others in general. Cancer is very nurturing, gentle, and security-oriented. The people who can help you most are those who can hold space for you, and help you re-enter the world in a nurturing way.