Also I think, I need to import coldcard wallet once again into wasabi for it to show reverted balance.
I will check that in wasabi wallet.
I'm not overly familiar with using Wasabi with a Coldcard, but isn't the Wasabi wallet set up as essentially a watch only or skeleton wallet, which just contains your xpub and addresses? It should update automatically rather than needing re-imported. If you re-import and it shows the correct balance, then for some reason your original wallet is not syncing/updating properly.
It is good that you don't seem to have lost any coin, but it still doesn't explain why the inputs to your transaction were declared invalid. Were they still unconfirmed when you spent them, and then later bumped with a higher fee? Or did you spend the same coins in another transaction?