I couldn't say for sure that some UNIX shell somewhere at some point did not do home directory wildcard expansion -- seems like a WMD grade foot gun, but OK -- but as you've noticed, tcsh does not do it and in fact even if you go back to csh in NeXTStep from 1989 it doesn't do it either.

Try it yourself: https://infinitemac.org/1989/NeXTStep%201.0