At 4093m it's not particularly competitive for longest total bridge length, although according to Wikipedia it has the fifth-longest cantilever span in the world and second-longest in the US.

It's close to the longest bridge in the United States only in the sense that the Lake Pontchartrain Causeway goes the other direction from one of New Orleans' northern suburbs across the lake. That bridge is 38442m long.