Microscopic Characterization of Scalable Coherent Rydberg Superatoms