The CDS and ADS endpoints are different, this causes the error. Sadly and confusingly so, they are set by the same file. Meaning you have to switch between them using session variables. A solution is provided here. Note that this exposes your key. I think you can just set the url, but you should cross reference the source code or ask the devs.
Reading along the source code of the python package here:
You see that you can set the url and key separate.
Keep you key in your .cdsapirc file only change the url using: