In my experience across 14 cruises, there is about a ten percent chance a port will be dropped or replaced after booking but prior to sailing, or else missed unexpectedly once underway, usually due to weather. Tender ports increase the odds, but having a pier is no guarantee of not missing a port due to weather.
One tip, always confirm the itinerary is still current on the line’s website when booking with a third party, as third parties may not be diligent in staying updated as things change. For example there is an Explora cruise I was considering until I realized St Barts was dropped, but some sites still have that port listed.