I haven’t worked much with the RealSense because I often want access to skeleton tracking in addition to the depth, and the RealSense didn’t offer skeleton tracking when it was released.

In general, I think both have strength and weaknesses. The Kinect has an overall better quality depth map than the RealSense, but the RealSense reportedly does better at shorter distances. When the RealSense was first released the form factor was a big advantage over the Kinect V2. The RealSense is much smaller than Kinect V2 and doesn’t require a separate power cord. This difference isn’t as pronounced with the Azure Kinect, which has a much smaller form factor (although with the microphones its bigger than the RealSense cameras) and has an optional separate power chord.

If you’re interested in reading more, here’s a nice comparison of depth sensors
http://docs.ipisoft.com/Depth_Sensors_Comparison

And here’s an easy to understand comparison of the underlying technologies
https://www.revopoint3d.com/comparing-three-prevalent-3d-imaging-technologies-tof-structured-light-and-binocular-stereo-vision/