CAM9 is not included in FSX, and it's not included in our scenery too as a starting location, although the seaplane base is modeled. I believe is included in the Vancouver+ scenery.
You see it way off in the sea, because we supplied an EXCLUSION AFCAD, that moves CAM9 out of the way in order to not screw up GSX at main CYVR in case Vancouver+ is installed.
The file is named CYVR_disable_AP.BGL, if you remove it, CAM9 and CYV2 (heli base) will both disappear, as if with the default scenery, since they are not included in the default scenery. But if you have Vancouver+ installed, you must keep it, otherwise they'll create issues with GSX at CYVR main airport.
If you want to go there, load your seaplane, slew to the seaplane dock and save a situation there. This is what you would have had to do anyway with stock CYVR, since CAM9 wasn't there too. Maybe we can also add a starting position there, but it will be still part of CYVR in the "Go To airport menu"