While I have no love for the paparazzi, and believe celebrities are often unfairly judged and deprived of basic privacy, I do not agree with you.
Tiger has carefully and meticulously crafted a certain image, and has used that image to create a brand. He had sold that image and brand to us and made millions. I'm sorry, but once you do that, you lose some of that right to privacy and judgment. If he (or any celebrity) expects us to buy what they are hawking by selling us a certain image of himself, that that image better be reasonably true. People are so upset and disappointed with him because they trusted him and who he marketed himself as, and now they (rightly) feel lied to. Sure he's human and fallible, and maybe he has been held too high on a pedestal, but he built that pedestal and has been selling stuff to us from it for years.
As an avid golfer and golf fan, I have been awed by Tiger's ability, focus, and determination, but I can't say I've ever liked him. I haven't hated him (other than for making golf boring to watch sometimes when he's winning every tournament), but have been indifferent. That is probably because I have never felt a human side to him. Sure he can be funny and witty sometimes, but he has always been so guarded, impersonal, and arrogant that he has been hard to relate to. That started to change once he got married and started having kids, he seemed to soften up a bit and seem more human, and I bought into the "family man" image he started to craft. Now that it seems like he's been serially cheating on his wife, and while she was pregnant no less, he seems more human all right, but one I have lost a lot of respect for.
Its funny that Phil Mickelson has always been the one accused of being fake and crafting a certain image, while Tiger, although distant and a bit arrogant, was lauded as genuine. While I'm sure Mickelson has skeletons in his closet too, I suspect (and hope) they are nothing compared to this. Phil has always felt more human to me, and has always been obviously flawed, but one place I feel Mickelson has demonstarted that he is not (seriously) flawed is as a father and husband. Tiger has failed at both, and has a lot of work to do to redeem himself in that regard.