Currently we only need an archive node for the Squid indexer because archive node acts as a big store for the events of each block, more particulary the blocks which are out of the “pruning window”.
It is just a convenient way to do it for the short term, but these events could be stored somewhere else.