Take a look at this site: https://tropicalcyclonedatabase.com/storm_tracks.html?_v=90

Filter Lifecycle Intensity by category 4 and 5.

You won't see any lines close to land near Cape Canaveral. Though to be fair, Vermilion Parish seems to be far enough west in Louisiana that it doesn't get direct hits either (but some are close).

Then look at the NHC Storm Surge Risk map: https://experience.arcgis.com/experience/203f772571cb48b1b8b...

Cape Canaveral is mostly 0-3 ft with some >3 ft. Meanwhile the entire immediate coast for the new Louisiana SpaceX location is >6 ft to >9 ft.

I think they'll probably have more a lot more trouble with storms than Cape Canaveral. The dynamics along the Atlantic coast are a lot different from the Gulf.