I would double-check to make sure python3 is using the correct CA bundle. On recent python3 versions, that should be the certifi bundle.
$ which python3
/opt/homebrew/bin/python3
$ /opt/homebrew/bin/python3 --version
Python 3.9.10
$ python3 -m certifi
/opt/homebrew/lib/python3.9/site-packages/certifi/cacert.pem
I was able to install and run cvdupdate without any errors on MacOS 12.2.1.
$ python3 -m cvdupdate config set --dbdir cvdupdate
$ python3 -m cvdupdate update
2022-03-07 11:40:26 cvdupdate-1.0.2 INFO Downloaded main-62.cdiff
2022-03-07 11:40:32 cvdupdate-1.0.2 INFO Downloaded main.cvd. Version: 62
2022-03-07 11:40:32 cvdupdate-1.0.2 INFO Downloaded daily-26474.cdiff
2022-03-07 11:40:36 cvdupdate-1.0.2 INFO Downloaded daily.cvd. Version: 26474
2022-03-07 11:40:36 cvdupdate-1.0.2 INFO Downloaded bytecode-333.cdiff
2022-03-07 11:40:37 cvdupdate-1.0.2 INFO Downloaded bytecode.cvd. Version: 333
$ ls cvdupdate
bytecode-333.cdiff bytecode.cvd daily-26474.cdiff daily.cvd dns.txt main-62.cdiff main.cvd
--Maarten