Statistics of A super-solar metallicity atmosphere for WASP-127b revealed by transmission spectroscopy from HST and Spitzer