At the time, Celine Dion's 2003 Las Vegas residency was viewed by some critics as a place where musical talent goes to die