Superconducting Radio Frequency Materials Science Through Near-Field Magnetic Microscopy