Atomic-Scale Antagonism Between D-Symmetry Cooper Pairs and D-Symmetry Density Waves in Underdoped Cuprates