A Pilot is important for such a journey but equally as important will be an astronaut who is a scientist by trade

Yes, there was only one scientist to fly on the Apollo missions and that astronaut was Harrison "Jack" Schmitt, Schmitt and Cernan helped collect the famous orange-colored soil from their Lunar journey.