OK, so lets say that you did understand the Zohar correctly. Now what? Does the Zohar mean that Hashem now hates you? Doe sit mean that you have no more meaning to Him? That you have no beauty and goodness in your life?
Sha"s says clearly that any person who embarrassess another in public has no part in Olam Haba. So if you once did that, and many of us certainly have, then what? What do you do about it? Do you kill youself emotionally by giving up everafter on living a deep, happy, and fulfilling beautiful life as Hashem's favorite 'ontheedgeman'-guy? Bishvili nivra Olam does not apply to you any more? Rubbish. Just plain rubbish.
It's a stain, period.
Neeeext! (or as Reb bards would put it: KEEP ON TRUCKING!)
I am serious. This is avodas Hashem we are talking about. It is your real life, not a religiously-contrived game of who is a "rasha" or "tzaddik", or who is going to gehinom or not going. And it needs to last about 80 or 90 years. Though we all suffer from it, the truth is that there is no real place for self-pity in this life. It is destructive and ruins us. It needs to be rejected as an option once we wake up. I frequently have to reject it, so I may know just how you feel...
If you are headed to gehinnom or can't do Teshuvah, then what? The way I see it, now you can serve Hashem even though you will not get a big fat honor-prize from Him for it...for after all, you have this stain on you. Nu. So you can now do what He wants for Him, instead of just for you and your ticker-tape parade in Gan Eden. We all envision something like that, you know...a ticker-tape parade. "Make way and open the gates for the tzaddik Shomer Emunim!"
Read the RMB"N's iggeres. 2/3 of the way down. So? Now you finally have a way to really see others as having an advantage over you, instead of having to manufacture one. This is nothing new. If you read the letters of many great tzaddikim and many simple Yidden from the past you will see this theme: "b'avonosai harabim asher otzmu v'robu misa'aros roshi...etc." Well, now you can say that and really mean it.
And exactly what is so bad about that? I think it is a fine place to start out. See where He takes you from there. He is very good at rearranging things and working them out so life works better, you know. He does that for me and lots of other people I know and does a fine job.
I know most of the good people around here are uncomfortable with anything but a touchy-feely, 'feel-good' kind of yiddishkeit. But I don't need to start with that. I have a G-d who loves me even if I would be a rosha c"v, and certainly even though I'd be right on my knees in that bathroom with a magazine open on the floor and 'getting the old shameful job done'. Hey, He was right there, too, with me, no? And He brought me here nonetheless! Isn't that love?
And that's enough for me to be in allegiance to Him for the rest of my life. Ashirah laShem bchayay, azamroh leiloay b'odi, ye'erav olov sichi - anochi esmach baShem!!
PS. I am not suggesting that you must do this. I am only offerring a way out for you - or rather, a way through (durch, in yiddish, I believe). Even your worst fears about this stuff can be a vehicle for you to live a better life.