Disentangling Types of Lattice Disorder Impacting Superconductivity in Sr2RuO4 by Quantitative Local Probes