It means Andy was a very bad dancer. That's all.
"Andy was a terrific dancer" means he was a very good dancer. You can also use "Andy was a terribly good dancer" with a positive meaning, as "terribly" emphasises the adjective: terribly good, terribly bad, terribly noisy, terribly annoying...