Well since she sang it at the superbowl the year you were born or there-abouts, I don't think you really understood the 'moment'. We were in Gulf War 1 under the first Bush presidency and we had the whole free world with us. It was a joyful, proud song and it resonated with a lot of people at the time, even becoming a hit on the top 40 playlist. So while you are entitled to your opinion, some of us actually lived through that period and found it uplifting.
As for as Whitney's untimely demise, it is true that she had a long history of drug abuse and it is easy to jump to the conclusion that she overdosed, but that is what the coroner will determine from an autopsy. However, sad or bad her ending was, she did give us some great songs sung better than anyone else in her generation. And she had an impact on scores of singers of who came after her. So perhaps her legacy is greater than we will ever know.