I am not an expert, but I would think it was woodpeckers, When they like a tree they will make many holes just like this in the tree

' green leaves that turned dark purple'

Purple leaves during the summer would not be red maple (acer rubrum) per se.

Most likely 'Crimson King' or 'Royal Red' Norway maple (acer platanoides).

Can't say for sure what, if any problems are present. The holes do look to me like some sort of woodpecker scavenging.

If concerned, an onsite inspection by an ISA approved arborist would answer all your questions.

If you're not all that concerned, just let nature take its course until it declines further.

If there is a danger of it falling on something of value, just have it removed and replace with a better tree of some sort.

You need a local arborist to look at it. I will say my family in Maine complained that this years fall colors were lackluster due to fall weather/ rain etc.

Woodpeckers look for bugs, so those holes mean that you likely have some bugs inside your tree. That said, I have a willow with an incredible number of holes and lots of woodpecker activity on most days, but it's been doing just fine for decades.

On the other hand, it could be from sapsuckers. They generally don't do much damage, but provide an entry for bugs and diseases.

carpenter bees attack my split rail fence.. dead wood.. and they used to attack non painted decking and eaves... again.. dead wood ..... but i never saw them attack any living tree with bark... and they are very prevalent around my house...

woodpecker or sapsucker... imo..

where are you.. zone alone is rather vague... big city name... your local county extension office might be able to give you a fast general answer as to what birds are prevalent in your area...

if you can find any leaves around.. we can probably ID it from those.. or in spring.. if you snap some better pix...

and add one of the whole tree ...

i would like to know if there was any weather event when the leaves were emerging.. or severe hail in summer.. is the tree telephone poled.. any recent excavation above the root mass.. etc.. we would need a lot more info to start figuring this out.. and it would be worth your while.. to learn all you can.. before you hire the expert to some visit... because he should be asking all the same questions.. so have the answers ready ...

ken