Singer says after campaign to save tour falls short, “Those few thousand tickets are a reminder that being transparent in failure sometimes can be more powerful than the facade of success”