I've camped there several times and have only been able to be on the front row, about 3 times, and only for a day or two. You have to be a relative, or a "great friend" of one of the campers on the front row. Then you can get them to bequeath their spot to you when they pass on. No kidding! I spoke to one person on the front row and they said that they had the one spot for about 15 years, finally decided to stop RVing and gave the spot to a best friend.
However, even the back row, is pretty good! you can see the beach/water and it is only a short walk out there. I've camped in some places that a bicycle or a car is required to get to the beach, when the ad says "beachfront"!