Oh, he's very tight with Bethesda and Todd, and he's very much into gaming. Now, it just so happens that he, due to his Tesla and SpaceX stuff, has all kinds of access to various people who can give very detailed and significant information to the dev studio on the various mechanisms and inner workings of pieces of real equipment and where the tech would be years from now IF certain challenges were solved, of which a videogame has no such limitation. And so Bethesda has no doubt been picking his people's brain, of which I'm sure he has gladly made them available to help since he's also looking forward to the game. He was also part of a sit down discussion where Todd Howard talked about the game. If you notice inside the stuff that has been show so far, especially inside the ships, they seem to have nailed the basic functionality of various things and have implemented them pretty well by the looks of what footage we have seen thus far.
I'm certain before long or come release we will hear about some level of his involvement on the game depending on how much Microsoft or Bethesda wish to highlight that aspect.