Can the Pioneer use the refined material made by the Orion (or any other ship)?

Yes, as long as what you are building uses that particular resource. Remember that there are different types of ores, metals and other substances used in construction.