Explosions Driven by the Coalescence of a Compact Object with the Core of a Massive-star Companion inside a Common Envelope: Circumstellar Properties, Light Curves, and Population Statistics