Yes, live resin carts smell like weed. But significantly less so than other methods of vaping cannabis. Take smaller and less frequent puffs, and no one will notice it as much.
While the taste of a live resin cart with all those terpenes is something you want to savor, these are the same terpenes that are making a scent you're trying to hide.