I think I knew that, thematically it makes sense. Trekcore has a breakdown of the scene.

Scene 20: Scotty feels sorry for himself because he doesn’t fit into the world of the 24th century. Troi tries to help, but only manages to make things worse.

After Scotty blows up at Geordi in Engineering, he receives a surprise visit from Counselor Troi, who mysteriously wants to know how he’s feeling. He admits that the experience of arriving in the 2360s has been “bewildering,” but declines Troi’s offer to assist with looking up the fates of his friends and family in the Federation historical database.

At this point, he stops the conversation and asks exactly what a “counselor” is. Troi reveals that the position began on Starfleet vessels “about forty years ago” – and Scotty suddenly realizes she’s a psychologist. “I may be old, but I’m not crazy!” he shouts, and storms out of his quarters, heading to Ten Forward for a drink.

Lost footage of James Doohan makes this the crown jewel of deleted scenes, and we’re so happy that it was able to be restored for this Blu-ray release. Ron Moore, the writer of this episode, had this to say when interviewed for the UK Star Trek Magazine in 1997:

“I hated to lose all that, but the show was eight minutes long and something had to go. It would have been nice to explain why she comes up and kissed him at the end!”