I wouldn’t call it archaic, but more folksy. I think most people would understand it, but would rarely encounter it outside a humorous context. It’s pretty similar to bamboozle, except that’s gained kind of a “cute” connotation in recent years (due to pet memes, etc.) that hornswoggle doesn’t have.