Just to add that I believe CSG nodes are meant just for prototyping. Not production. There are plenty of warnings too in the docs that doing certain things, like how they are created in your tree, can impact a prototypes performance.
I think you have to convert them to Meshes.
Converting to MeshInstance3D
Since Godot 4.4, you can convert a CSG node and its children to a MeshInstance3D node.
PS (Edit) Reading further about this I found this comment:
In summary, while CSG nodes excel at prototyping, they are versatile enough to be used for final game elements in specific scenarios where their limitations are acceptable.
So not “just” for prototyping, if you can live with the potential performance impacts.