Which adapter you will need depend upon the charger and what type of plug it has. You can't necessarily define that by a given network.
There are many ChargePoint chargers which I have used that are set up for J1722 connections, so you can use them with the J1722 adapter which you have. However, that does not mean there are not some other ChargePoint chargers which might be CCS or possibly CHAdeMO.
Plugshare is not a single network, but a site that will show you charging locations across many networks, including ChargePoint, EVGo, and event Tesla Superchargers. What you need to do is look at the details of the specific location, see what type of connectors they list, and then that will determine what type of adapter you will need. You can do this on Plugshare by clicking on the specific location and pulling up the details to see number of stations and types of connectors. Some will show multiple types. For example, your location shows as Rancho Mirage, CA. I just glanced at Plugshare and happened to pick the EVGo chargers shown at Ranch Las Palmas shopping center. These shows as having both CCS and CHAdeMO connectors. Going forward I expect it will become CCS to be the most prevalent, so if I were to invest in a single adapter, I'd likely opt for a CCS adapter (just my opinion).