Yes, we often use it when we have forgotten a word or phrase

Howdy Alina. Yes, it is pretty common to say that something is “on the tip of my tongue” when you have difficulty recalling a specific word.

Hey Alina, yes that is a common phrase, especially in the UK. :)