I think Vingegaard came here to try and win the race. He did really well in the first half of the race, limiting the gap that many people (including, seemingly, Visma) had been expecting would be substantial. Then he tried to make the same move he's made the other years to take the yellow jersey: crushing tempo on a long climb deep into the race. But it backfired because Pogacar's level was even crazier. He seemed surprised - and gutted - that it didn't yield the result he had hoped for (and maybe expected).Even if he is really tired now- it should not come as a surprise to anyone. Some commentators seem to have forgotten almost, what happened in April and thereafter (ICU, only 6 weeks proper training, etc. - we all know it). What he showed so far is much more than anyone could have expected. I think he is happy what he showed so far, including the stage win. If he can pull something off tomorrow or Saturday, it would just be a bonus on top.
Personally, I can't believe he's able to be in 2nd at this point in the race with what he's been through - far beyond everyone except Pogacar and Evenepoel. But I don't think he's happy with that. He wanted to win.