Climeworks' technology is the real deal, and needs to thrive. The only good CCS is 100% carbon negative and sequesters the carbon in chemically stable forms. This is it, and we need more. Petroleum industry CCS is a scam, but Climeworks is not that. Disclaimer: I'm biased because I'm Swiss and so is this technology.
We hackers like to believe there is a technological solution for everything. These projects feed that delusion. Massive reductions and degrowth are hard for us to accept. This article somewhat fairly explains how extremely impractical and unlikely carbon capture technologies will be. The investments in the technology and the PR around them serve more to feed the delusion and keep us burning as usual.
In any case, at this point even if we stopped emissions tomorrow we'd still need negative emissions to get back to a safe level.