Fished there a couple of times early this spring for bass. Nice launch at the boat ramp or beach (before the crowds arrive) with ample lit parking lot.
Couple of things to keep in mind:
1- Beesley's Point Sea Doo and jetski rental is on the west side of the bridge. That area probably sucks after 9:00am on weekends with the jetski traffic.
2- As Chris said, the current does rip through there at times so watch the tides. The channel was fishable during slack tides but it was very difficult to hold position once the tide started to run. There is a ton of debris and structure under the old Rt. 9 bridge which is probably holding fish.
After looking at the deteriorated condition of the old bridge, I really wasn't keen on spending a lot of time under it. I kept picturing the old bridge falling and the newpaper headlines reading, "Bridge squishes kayker". But that just me.
I'd definately give it another shot if I could catch the tides right during the "off" hours.
Good Luck!