Avalanche terahertz photon detection in a Rydberg tweezer array