The reason they are doing this is that they hope to eventually colonize the moon. Finding water there would mean we could harvest it for any people living there.
Watched it yesterday morning, I didn't hear if they found water or not, but I heard the mission was a success.