Neurointensivist here.
That is a ridiculously bad (or perhaps just outdated) opinion. Was this an endovascular neurosurgeon speaking recently? Sounds like a generalist who was commenting off the cuff about something too far outside his area of expertise.
An aneurysm not being visible on CTA does not mean it won't be visible on DSA. It is quite common to not identify an aneurysm on a CTA and then identify it on DSA. And just because the spacing on CTA slices is < 1 mm does not mean that an aneurysm to be missed has to be < 1mm. Missed aneurysms do tend to be small, typically < 3 mm (at that size the sensitivity of CTA for aneurysms drops dramatically) but are definitely not all sub mm. Unfortunately, while the rate of initial rupture correlates with size (among other features), the risk of re-rupture of these very small aneurysms does not seem to be particularly low. And re-rupture doubles the expected mortality.
Even if it is not identified on the initial DSA, standard practice for these "angio negative" SAHs is to repeat a DSA some time later, typically about a week. A little less than 10% of the time an aneurysm is identified on the repeat DSA. This might be due to it initially having clotted off on the initial DSA (which is why we give it some time to allow the clot to resorb, otherwise its likely the repeat DSA will be false negative again) or due to some hyper acute spasm, even apart from limitations in technique. Until the repeat DSA is also negative, we treat the SAH as if it were from a ruptured but unsecured aneurysm (ICU, q1h neuro checks, SBP <140, nimodipine, TCDs, keppra).
As for the treatment of very small aneurysms: while more challenging, it's not like there are no treatment options. They may not be amenable to clipping or coiling, but they may very well be amenable to a flow diverter. There are untreatable aneurysms, or aneurysms where the treatment is too risky to try, but that's something that's decided at the very least after a DSA and likely conferring with a couple of other endovascular neurosurgeons.