The legendary character actor plays a retired gay icon in a gently melancholy film that is elevated by one genuinely sublime scene