It's okay enough. I agree that the meaning is lovely but I don't like the prominent ror in it or the boyish Rory. That seems even worse.
Temperance is nice as a middle name but Tempy sounds like a nickname for a part time receptionist or a temperamental kid. Out of the two I would go for Rory despite disliking it.
Silly but I think Aura would be a cute nickname.