The extragalactic explosive Universe: the new era of transient surveys and data-driven discovery