Although I presently do not own a Kayak, I have been to the Cross Island Pkwy area many times by bicycle. Yes there are many people who launch their Kayaks from the ramp there. Many of them park across the Criss Island and come across the foot bridge. Some use Dolly Carriers, and others just carry the Kayak.
From Little Neck Bay, one can fish the shallows towards the south, or the rocky coastline on the Great Neck Side.
Ft Totten is just north of the area, and provides challenges with many species of fish. I fish by boat in the area, and Little Neck Bay is one of my favorite areas to fish most of the summer.
The Marina at that area is open to all, and there is food, and rest rooms.