I've had my a-pillar trim off and got it back on correctly. What is pictured in the post above is an installation issue. I'd remove that and try again.
I use aluminum rivnuts fairly regularly. They are fine in the right use case. You're just steadying a snorkel here, not putting a bunch of load on it, right?
I buy them in kits with assorted metric sizes on Amazon. Pretty sure industrial suppliers like McMaster Car have them too (I've purchased steel SAE threaded inserts from them).
You can also buy metric step bits on Amazon. I bought a set of three that was inexpensive and has served me well. Some things (like the LRA tank gauge/switch) need a snug fit (rather than close enough) that metrics bits can give you. Most of the time a standard bit size works well, but some things are better off with properly sized holes. Rivnuts can rotate if you drill the hole too far oversize and they don't grip.
My install tool has a depth adjuster that can be set to prevent over compressing the rivnut (and blowing out the threads). I am unable to physically squeeze past this stop (it is basically a threaded aluminum rod that limits how far the handles can close).
Test a spare out in some scrap material to ensure that you know when to stop.
To get around the issue of hitting the inside sheet metal when installing, you should be able to put the rivnut on the tool, insert the rivnut partially into the hole without putting it in full depth and begin to compress the rivnut, then push it inward until it is flush as you compress it to final fitting.
I like RET2s staking ideal. I'll have to do that going forward.