Redneck Beach, as it's become known, refers to the area on the west end of the Destin Bridge that is in fact land designated for public use by the United States Air Force, who controls all of the beach access on Okaloosa Island. This particular beach access is quite popular because of it's proximity to Crab Island, ease of access, and it's plentiful parking. There is plenty of beach that stretches from this area underneath the Destin Bridge out into the Destin East Pass, but this requires a fair hike. As a result, crowds tend to bunch up near the foot of the bridge and because of it's close proximity to Crab Island, boats frequently anchor on the shore here, attracting a much more rowdy and loud sort of crowd.
If you're looking for a more family friendly beach access, this is still a good fit but you'll have to hoof it on foot quite a ways down the beach out towards the Destin East Pass to find a bit of peace and quite. With that said however, you still get gorgeous views of Crab Island, the Destin Bridge, and much of the Destin Harbor from this beach access.