It sounds deeper, but im pulling it and check everything.Cracked flexplate or crank bolts loose?
Some of that looks like aluminum, if it is the trans your suspect.
I looked inside and it has some in it, im thinking the is pump trashed to maybe broke a chunk off and float around making the tapping noises. Trans is going to come apart this weekend for inspection then go from there.
Gotta relieve stress somehow!That tapping noise may be from those Miller Lite bottles rattling on your bench. LOL