Generally speaking, the pier is fishable at all states of the tide,but, obviously, the water is quite shallow at the entrance. Having said that, I recently caught a bass at low water at the beginning of the stem. At this time of year, however, you will find swimmers,jetskis and the "beach patrol" rib well within fishing range! This mark is also noted for sole.
An alternative spot is the club hut a bit further down on the right. Again, it's shallow at low water, but you can still catch fish.
There's always a reasonable depth at the end of the pier. The pier fishes better on the ebb, but I try and pick a tide so that I can fish 2/3 hours up and 2/3 down.
Anyway, give it a go at any time. You may get a surprise!!