That pretty much confirms it's inside the trans.
Though, when I had 2nd let go on one, it broke off an entire tooth on the small gear only make a light clicking noise, and lodged the tooth in the center section. Draining didn't find anything, only taking apart showed the issue.
Though with how old yours is, it might also be loose bearings causing enough slop to make that constant noise