As long as your outta there by 11:00pm when it closes, I guess. With all the bouys, channel markers, and lack of a launch area at the causeway I wouldn't suggest that location for a good night ride....especially since new riders may heed your advice. It's tough enough to ride there during the day.
Honeymoon would be a much better option...