Disentangling types of lattice disorder impacting superconductivity in Sr2RuO4 by quantitative local probes