If you can't afford anything else then this would do the job. No image stabilisation.
It's basically pretty much a 25 year old design with the new RF fitting on it.
I'd not waste my money on it, if I couldn't afford the next lens up (RF 100- 400 5.6-8 USM) then I'd suggest using an old 2nd hand lens with an adaptor.
I returned this for the RF 100-400 5.6-8 USM Lens and I'm so glad I did. It was worth over double the money.
Honestly... I don't recommend this because your camera body with an RF fitting is capable of using much better lenses... So this one would hold you back a little.