Introduce myself as a fellow author? He's a multi-award winning author and I'm just an idiot with a couple of stupid books that barely anyone has read, let alone heard of.
You're right, Heinlein, Asimov, Tolkien, whatever, started out with their first book being immediately sold 50,000,000 times in their first weeks.
Of course you're a small time author right now. Everyone starts there. The times have changed, and these days there's an absolute glut of wannabe authors self-publishing through the internet. It's even harder than before to get recognized, to gain some traction. You, however, managed to get your first
two novels published, by an actual, real, paper, brick-and-mortar, publisher. Know what happened to Heinlein's first novel? Never published. Asimov's? Published after his death, when they found the 50-times-rejected manuscript.
Going up to him and saying "hey colleague, how's it hanging? I've never read any of your work" may be arrogant. I don't actually know him or his works either, so I don't even know what genre it is, but try going up to him, asking him about his start, the troubles with getting published, whatever, without whining. Engage him, ask him for tips to get recognition, what do I know?
Some authors will look down on young upstarts. The same is true in other careers. Frankly, they're jackasses, for the most part. Everyone started out young and inexperienced; the good ones who made it will be willing to talk to young newcomers and help them.
I know it's a cliché, but you've got nothing much to lose. Even if he outright rejects you and laughs at you - I'm fairly sure he can't be more negative about you than you are already yourself (this is not a compliment. Think positive. You're awesome in many ways.). If you've got the tickets, go.
And as for your job - not calling can mean "it's all okay, we expect you on Monday" just as easily as "you don't have to come in anymore". Frankly, if the latter, I'd expect them to call to hand in credentials, uniform, sign papers, and so on. If they didn't tell you literally and to your face "don't bother coming in", go in, or call to check. It's not because you're currently in a funk and somewhat hating yourself, that everybody suddenly hates you.