It's actually just short of 24 miles, which is plenty long enough. I've never had problems with the Lake Pontchatrain Causeway - it's low, flat and straight (just like many miles of I-10 to the west of the New Orleans area).
Now, the Huey P. Long Bridge across the Mississippi River... that one will give me the cold sweats. There's also a fairly new cable suspension bridge a few miles upriver of New Orleans; I swear you can feel the damned thing moving when it's windy.
There's one not too far from here just out from Pottsville, Tennessee that spans the Duck River. Are ya'll impressed yet?