I’m sitting just inside the harbour entrance right now. Lovely little harbour.
Anyway, to gauge access to the harbour, your best bet is to use the harbours bar ride height gauge :
https://www.bembridgeharbour.co.uk/weather-and-tides
So right now, on an ebb tide, 3 hours after HW there’s still a couple of metres of water over the bar according to their gauge. There’s still water round the marina at low water, but it does get quite dry elsewhere, so if you plan on being in harbour through low water, choose your mooring carefully