"Wake up and smell the coffee" = "Look at (and accept) what is happening in front of you"! You're saying that the person is living in a dream, and not focusing on reality.
"You're not going to be a famous musician! You know two guitar chords and you never practise! Wake up and smell the coffee!"
"Your wife is not going to come back to you. She's left you and re-married. Wake up and smell the coffee!"