Manchester United supporters still hold Wayne Rooney fondly in their thoughts but visiting the Theatre of Dreams has become difficult for him