I, too, am excited to see where all these story threads go. There is a large amount of good narratives here.
Your post had me right up until the end, though, that is some Sixth Sense level of rug pull.
The story in Starfield is never going anywhere, Dr. R. That's the trick.