If we could turn it to become a resource, perhaps it will be consumed out, just like the rest of resources we humans discover.
One possibility maybe applying photosynthesis, if we knew how to do it in a practical manner. We know that plants can do it, we know generally how they do it, but still can't replicate it.
With photosynthesis, the CO2 ends up in some form of sugar among other things. Where the hydrogen comes from water, and we want that hydrogen for energy.
Of course, as with anything done by humans, there's a danger of abuse. In such case, we could 'overharvest' the CO2 such that it could starve the plants, leading to oxygen shortage... And that's another doomsday scenario.
All in all, the problems point at the humans, so far Earth tolerates us.