You asked
Is the canon rf 800mm f 11 is stm good for sports?
Here is what the site says about that.
From Canon RF 800mm f/11 IS STM: Canon RF 800mm f/11 IS STM: A prime lens by Canon for Full frame cameras, 800mm f/11. Specs - Maker: Canon - Focal length: 800mm (prime) - Maximum aperture: f/11 - Made for: Full frame sensors - Mounts: Canon RF - Stabilised: yes - Autofocus: yes What it frames like - On full frame (Canon RF): as marked, 800mm. - On APS-C (Canon) (Canon RF): like 1280mm on full frame; f/11 gives about the depth of ...
From Wildlife and sport: Wildlife and sport: Wildlife and sport are the hardest things to photograph, and the most gear-dependent. The subject is far away, it moves fast, and it won't do it again.
Quoted from this site's pages.