Towards Quantum-limited Measurement with the Radio Frequency Superconducting Single-Electron Transistor