The Within Temptation frontwoman and former Nightwish singer would eventually team up for a blockbuster single