The nature of the CO is one Triplebond, plus for each atom one nonbonding e-paar.
With this in mind you are right, if you think of it as a “clone” of N2, because nearly all physically properties of both are close to indistinguishable.
I know in the moment only one difference of both, as only CO has a recognisable dipole moment, of course not an extremely one, because C (EN = 2.5) and O (EN = 3.5) are quite close together.
CO2 in contrary has not “any” dipole moment, because it is linear in the form: O=C=O with the required nonbonding e-paars on the O. That means that the centres of both charges are located inside the Carbon.
As the molecule is very stable, tells you the corresponding acid will be of very week nature.
I hope, it gives you the wished ideas.