It should work great for doughing-in, sparging, and CIP (after spent grain removal of course) but my guess is that it won't work well for recirculating the mash as small grain particle might clog it. (I'll test it out next brew day and report back.)
I'm also testing another solution and I have another video that I'll eventually post -I bought a replacement of the internal spray head for one of these sprinklers -it's VERY tiny and you can just barely stretch 1/2" silicone tubing over it. This would take a lot less physical space within the vessel than the full sprinkler assembly and works great if you have hose barbs on the inside vs. NPT threads. It's about the same price as the whole sprinkler head, though; also around $2.
I believe the spray head itself is 5/8" in diameter and I just held the host on with a releasable zip tie for testing.
If you're leery of PVC this would be a more ideal solution than using the whole sprinkler head assembly above as you would only have a very tiny amount of PVC involved.