"Sofía" is Mario Bautista missing someone he keeps losing to his own schedule. The problem is laid out right away: "Tu vida no es como la mía" (Your life isn't like mine), and they are always "de hotel en hotel" (from hotel to hotel). He even owns up to it: "Sé en cuántos cumpleaños, mami, yo falté" (I know how many birthdays I missed, babe). Mami here is just a pet name, like "baby", not his mother.
The chorus is where it hurts. Without her, it's "sábanas frías" (cold sheets) and "copas vacías de gin" (empty glasses of gin), and "Busco en otras lo que no encontraré" (I look in other women for what I won't find). Notice the verb faltar in "cuando me faltas": it literally means "when you are missing to me", which is how Spanish says "when I don't have you". It's a handy structure to learn, and it works just like gustar.