Andor creator says the season 2 finale’s poignant twist is meant to end the series on a “hopeful note”