Yeah, in the long run being resistant to normal weapons would not help vampires much in a confrontation with the entirety of humanity in the event of the Masquerade being broken worldwide. As was said, there's fire, which is probably the most crippling weakness among nWoD gamelines. And besides, Bashing damage will bring you down eventually. A vampire will endure under a hail of gunfire far longer than any mortal, but he'll eventually go torpid.
It would, though, help them in confrontation with individual mortals, like hunters, law enforcement, criminals or other vampires' thralls. Of course, going into close quarters with a vampire is very risky for a mortal anyway, so those who know they're up against a vampire are likely to use fire and otherwise fight smart regardless.