The IPCC, the IEA, and a boatload of scientists disagree. We cannot prevent catastrophic global warming without doing the type of CCS you describe as useless. Sure, we also want to be doing stuff that's net carbon negative, but that's a long way into the future.
And CCS from power generation is only one aspect. CCS from cement plants, steel furnaces etc. is another thing we need - those processes will inherently emit large amounts of CO2 even if electric power is 100% renewable.
Finally, when it comes to capture from air, I think stuff like "biomass -> syngas -> water shift -> separation of CO2 captured and stored, H2 produced for energy" is much more likely to be successful, because you can make it net CO2 negative and it produces something valuable as a byproduct. Capture from air is a whole 'nother matter, starting from a very low CO2 partial pressure and thus very inefficient.
(I work in CCS, happy to answer questions.)