The singer-songwriter returns to the SNL stage as musical guest after nine years away