Earlier quoted context omitted.
Even if this thing in the ocean is just a lump of heavy metals ejected from some remote cataclysm, that would still be interesting in its own right. Is it really so terrible that he wants to go and look at an actual physical thing from space instead of finishing his career staring at computer screens? Give him a few million dollars and let him have his field trip.
He deserves way more than that, but the issue isn't that he wants the field trip. The issue is that he's saying that it's to hunt for alien tech. There are missions all the time to recover remains of meteoroids that didn't burn up. https://www.nasa.gov/feature/goddard/2018/antarctic-meteorit... But people don't exactly go running around saying that they're trying to find Thor's spaceship from that time O'Neill, Carte…
You do make a good point about conspiracy types, but I don't think it's necessarily his responsibility to educate everyone out of that. The best way to let the air out of that particular balloon is to send a small rover to the moon and land it near the original Apollo site, and then just drive it around beaming back pictures of stuff on the moon and attractive hi-res pics of Earth on a daily basis.
Does it break any new scientific ground? Nope. Will it do wonders for public awareness of/engagement with science? Hell yes.