The bottom line is there is no real evidence that this took place.
If Jesus death had caused such scenes as have been mentioned especially in Matthew such as;
Matthew 27:
52 - and the tombs broke open. The bodies of many holy people who had died were raised to life.
53 - They came out of the tombs after Jesus’ resurrection and went into the holy city and appeared to many people.
54 - When the centurion and those with him who were guarding Jesus saw the earthquake and all that had happened, they were terrified, and exclaimed, “Surely he was the Son of God!”
55 - Many women were there, watching from a distance. They had followed Jesus from Galilee to care for his needs.
56 - Among them were Mary Magdalene, Mary the mother of James and Joseph, and the mother of Zebedee’s sons.
There would have been untold records / information of this amazing event, yet nothing, regardless if it was a local event.
Regardless of where Jesus was actually crucified (see Exactly where was Jesus crucified?) no witness could have been present and watching Jesus die and at the same time present and watching the veil tear.
That in itself raises significant questions.
There are significant contradictions in the gospels of the crucifixion – see: https://hermeneutics.stackexchange.com/a/62267/33268
The strongest evidence that it is unlikely that this even occurred is from - Flavius Josephus
Jewish War, Book V
But the inmost part of the temple of all was of twenty cubits. This was also separated from the outer part by a veil…
It was a Babylonian curtain, embroidered with blue, and fine linen, and scarlet, and purple: and of a contexture that was truly wonderful. Nor was this mixture of colours without its mystical interpretation: but was a kind of image of the universe. For by the scarlet there seemed to be enigmatically signified fire; by the fine flax, the earth; by the blue, the air; and by the purple, the sea. Two of them having their colours the foundation of this resemblance: but the fine flax, and the purple have their own origin for that foundation. The earth producing the one, and the sea the other. This curtain had also embroidered upon it all that was mystical in the heavens; excepting that of the [twelve] signs, representing living creatures.
Not a single mention that previously the veil had been torn.
Conclusion
Either we no longer have the sources that existed or that this is a made-up story.