I fished around there last Summer and Fall. It was a little shallow even by sound standards, but perhaps that was the tide. I could get a kayak all around it without issue, but just on the inside of the bridge I was bottoming out the pedal drive which requires ~18". We were looking for Sheepshead, but didn't see any. I caught a small flounder, smaller than keeper size had the season been open.
In that area I prefer to be outside of the bridge towards the duck blinds. If you look off to the west while on the bridge you can see where the grass starts. The area against the bridge is sandy and largely void of anything to attract fish, but just 100-200' feet off that all changes. You can also see it on Google Maps satellite view. I've caught some decent trout and hooked what I assume was a slot drum there. The area to the south of the channel headed towards Hatteras Jack is decent, too.
IMO better fishing is to the south, but the boat ramp there is nice. If you have a cast net and want fresh finger mullet the deep water there by the ramp is absolutely loaded with them.