Dame Judi Dench greeted with overwhelming reaction after realising ‘dream’ with rock star