This is called Carbon Capture and Storage and so far it has never been worth it energetically. And the only companies doing it are oil companies in a process known as enhanced recovery which pushes more co2 out than is pushed in. The OP was right. Better to leave it in the ground

I've wondered if capturing carbon emissions from industrial-scale compost facilities would be a net positive. It would have the added benefit of the carbon initially being captured by natural organic processes (i.e. growing food), so it avoids the problem of the energy requirements from trying to just pull carbon from the ambient atmosphere. I don't know if this is feasible but I haven't seen any research on it.

I think OPs point is this tech is good only if you sink it after.

I. e. Collection is half the problem.

Collecting it in a way it's cheap to get it back again is potentially just less than minus half the problem.