Why was the tet offensive bad for US

Raised hard questions like, there was close to 500,000 troops in vietnam and USA was spending $20B a year so why were VC able to launch a massive attacked taking US forces by surprise, US and SV forces quickly retook the towns captured but they used lots of artillery and air power killing many civilians and destroying the ancient city of Hue was this right?