I suppose whether there's a "point" to playing the game on the consoles anymore depends enormously on what kind of gameplay you want.
Sure, you won't get the newest community goals, thargoid war, and other storyline stuff, nor any new content (such as new modules or ships), but there are many, many players even on PC / Odyssey who don't care much about those either, and would mostly be just as content with the legacy/console version as they are with Odyssey (minus the on-foot portions, of course). There's still quite a lot that the game has to offer in its legacy mode. Maybe you won't get the excitement of seeing a Titan explode live, or to boost at ludicrous speeds in supercruise, but in the grand scheme of things those are not the main impetus to play the game anyway.