A SPectroscopic survey of biased halos In the Reionization Era (ASPIRE): impact of galaxies on the circumgalactic medium metal enrichment at z > 6 using the JWST and VLT