No. An E-mount lens needs to be exactly 18mm from the sensor, and L-mount is 20mm; but RF-mount has the lens flange 20mm from the sensor. So there's no way to get the lens close enough with an adapter in between. In any case that's an electronic lens, so it wouldn't be compatible with any camera brand it wasn't designed for.
There may be a diopter adapter -- where lenses inside the adapter itself extend the focus distance of the lens -- but all the info I've seen says that these have a terrible effect on image quality.
If you want to know more about lens compatiblity, I wrote an article about it: https://moonblink.info/MudLake/gear/lenses
Yeah, we have been waiting for third-party autofocus RF lenses for quite a while. (There are all-mechanical manual focus lenses.) I don't exactly know what the deal is, but we're still waiting.
If I were in Canon’s position I would want to fill out my lens lineup before I opened up the mount to third party lenses. The last thing I would want would be for some third party lens become the de facto standard lens for the RF mount.
12/05/2023: New firmware updates are available.
09/26/2023: New firmware updates are available.
08/18/2023: Canon EOS R5 C training series is released.
07/31/2023: New firmware updates are available.
05/18/2023: New firmware updates are available.
03/30/2023: New firmware updates are available.