It doesn't matter whether you're interested in Odyssey - Odyssey is interested in you. Or, more accurately, you now have the choice between base game, Horizons 3.8 (old graphics, not involved in future content) and Horizons 4.0 (new graphics, future content). If you buy Odyssey, you can get base game, Horizons 4.0 or Odyssey. The "futture content" is expected to be connected with the Thargoids and might arrive starting from November.
The downside is that, for playing in VR with a G2 headset, you'll need a good GPU - 3090 or 6900 class is what I would say, others may have a different opinion.
As for goals, nothing has changed - you still need to set them for yourself or take one from the player community, unless you want to engage in the FD narrative, which will (likely) be centered around the Thargoids.
Oh - not sure if they already were around when you left, but now you can get a personal fleet carrier. Starting at 5 Billion Credits, and easily twice that if you add a few optional extras and want to stock up on running costs (yes, they require a weekly payment of a few millions) for a few years.