I honestly do no see the point of code CAD for anything but a couple limited cases. Designing is an inherently visual process and you lose a lot by working with code.
In modern CAD software one already does 'programming' by specifying geometric constraints. For a great example of the power of this approach, see Ivan Sutherland's sketchpad. Specifying geometry using equations as one often does in code CAD is a much more difficult process than specifying geometric constraints. For example, specifying that a hole is some distance from the edge of a part is quite difficult with code CAD.
In addition, there are already multi-user CAD approaches for doing CAD design as part of a team. BYU's multi-user CAD system is a great example of this. I can't find a video, but it claims to be google docs for CAD, allowing users to edit the same CAD model in parallel using extended versions of commercial CAD software.
Honestly, I think the only reason why code CAD is popular at all is that no good open source CAD software exists, so manual use of CAD kernels is filling the void. Although, FreeCAD is continuing to improve so this may change.
BREP is not necessarily futureproof too. At the current time we can manufacture more complicated parts than we can design. With additive manufacturing we can make very, very complicated parts. [0] gives a great example of some. At the current time there are printers which can make centimeter scale parts with micrometer-scale geometry and there's good reason to believe that the same printing process can be scaled up. Describing a 1 meter cube with a micrometer scale lattice structure using triangle based formats takes something like 500 TB.
Additive manufacturing is also capable of printing multiple materials too. In some cases you can even mix material together, to say have a gradient going from soft to hard material. So there is now a need to describe material composition and be able to describe how that material composition changes in 3d space. Things get particularly weird if bring composites into the mix too. There are number of very different approaches to solving these problems. Some proposals include voxels with 3d textures, volumetric-representations, and even some approaches based on functional programming[1].
[0]https://www.researchgate.net/publication/317614395_Nanolatti...
[1]https://www.sciencedirect.com/science/article/abs/pii/S00104...