Unless it was economic to extract the oil and return it to earth (which it would not be) the discovery would be mostly of a scientific nature. However, finding hydrocarbons on the moon would be a good thing insofar it would provide a ready energy source for any future moon-based operations.

The reason oil is so popular is because it is so useful. Anything useful is in high demand. There's no need to get hysterical about it.