Yes, but to be pedantic, no, this is a short term rise in CVEs.

This is a shift in the equilibrium of difficulty to find these exploits, but there are increased defensive tools and new awareness of these issues as important. There will be a large glut of AI detected bugs, there are decades of code surface to scan and clean up, so this will last a while.

Eventually net new software will end up being written in a more secure way, and important old software will be patched or replaced, or taken offline.