While Grande and Davidson's relationship might have ended with a bang, the insider told Daily Mail that she looks back at it as 'a loving moment in her life'