AP piers
With the low tides recently, there may not be a lot of water under some of the piers discussed. When I went past the Conn Brown Harbor pier 3 weeks ago, there was a lot of exposed mud directly under the pier.
Wilded, if you own the kayaks you cited, or at least have around the clock access to them, you guys might want to kayak the canals in Key Allegro at Rockport. Lots of lights up and down those canals, plus they offer protection from the wind. You can launch at Little Bay park and be in the Key Allegro residential canals in a couple of minutes.
The pier at Goose Island SP is also a good spot for wading. There's a staircase down to the water midway down the pier that will put you near a gut that runs under the pier. Good luck!!