Congratulations on the impending new arrival. Parenthood is a very rewarding roller coaster.
I'm in the "hate" camp when it comes to the X6 but who cares what my opinion is. You got what sounds like a great deal on the car you wanted and that's all that counts. Plus you have the 997 on the drive to balance out the pretty/ugly scale
With regard to big cars for families. I don't get it. We've got 2 kids and our biggest car is a Grand Vitara. My wife previously had a Seat Ibiza and even that was big enough for all of us including baby seats, ride on toys, prams, buggies etc