Is this pipe in my basement floor intended for radon mitigation?
Yes, your area is known for radon and it It looks like pipe is the rough-in for a radon system. 

When we install radon piping, we install a series of perforated pipes embedded into gravel in the crawl space or under a slab-on-grade floor. We also provide a series of pipes in the ground around the exterior of the building too. 

Usually the two systems are not connected, but work in tandem. The exterior pipe and gravel provide an inlet for air, so the interior pipe and gravel can exhaust the air under the building. However, the exterior gravel needs to be "connected" to the interior gravel (gravel under the building,) so air can be drawn through the gravel under building to purge the area. 

The reason the two pipes seem to be connected is that the two gravel systems are connected. 

However, the interior solid pipe (not perforated) needs to be extended through the attic and connected to an exhaust fan. (Often the interior pipe is extended through the attic/roof without an exhaust fan. If tests show radon has decreased, then we never install the exhaust fan.)