the sauropods were nearly extinct by the time of the k-pg impact, so this is clearly an entirely different comet that had a lovely time and left without causing any major event to occur
The titanosaurs were the last surviving group of long-necked sauropods, with taxa still thriving at the time of the extinction event at the end of the Cretaceous. https://en.wikipedia.org/wiki/Titanosauria