I am totally opposite, self realized, big career and travelled a lot. I am not an adventurer and adrenalin seaker, quite the opposite, but I have great self confidence and am not afraid of life.
I am trying really hard to somehow raise our boy in this respect but its really hard because she paints a totally bleak picture of the world.
Well it's wonderful that your son has a dad like you. Surely he sees in you somebody who went out and made life happen. You can hope your son will take after you that way.
One thing you might try to nurture in your son is a growth mindset, instead of a "scarcity" mindset that your wife harbors. I can't help but think of a quote in Little Miss Sunshine: "You know what a loser is? A loser is somebody who's so afraid of not winning they don't even try." So for me, the outcome is less important than the consistent effort. Adulthood is about taking responsibility for your life and making things happen, which requires effort, day after day, week after week. The great part is, you have complete control over your effort, unlike many other things in life. If you think about potentially "scary" situations, maybe you work out, what's the worst that could happen? Getting fired? So what. If you get fired, you reflect, try to learn from it, move on and start looking for another job. Chances are you might get an even better one. Fail a test? So what. You study harder, get some tutoring, retake the test, or maybe redouble efforts on subjects that are more suited to your interests and abilities. Like Churchill supposedly stated, "Success is the ability to go from failure to failure without loss of enthusiasm." Failure is an excellent teacher. Not only that, but it signals you're shooting high. Since you're a successful guy, I'm sure you get what I mean here. I think most successful people are exactly where they are because they don't let little setbacks derail them, and instead learn from them. That would include a difficult childhood or growing up with a disordered family member.
My guess is your son will be more like you, because it's way more fun to have an optimistic, growth-oriented mindset. With whom would you rather hang out: Tigger or Eeyore? I think most people, including your son, would pick Tigger.
As for BPD, that's why I think the worst part about it is the victim mindset. Blaming other people all the time and feeling victimized at every turn basically renders a pwBPD powerless. I think of it as a sort of learned helplessness. How awful it would be to feel powerless, insecure, incapable in everything important in life, blaming others, feeling dependent and needy, feeling aggrieved all the time, giving up before trying. What a drag.