No free lunch: The trade-off between heralding rate and efficiency in microresonator-based heralded single photon sources