Depends on the person. For me, I wanted to do it again. However, I've taken people to the range who got in there and didn't even want to pick up a gun let alone shoot it.
I took my wife to the range once and while she was glad she did it she never wanted to go back or shoot one again. Our son, on the other hand, has gone with me a couple times and he really likes it. I took my sister and her husband to the range and they both shot some of my handguns. Sister didn't really want to do it again, her husband did, and has (they still don't own any guns though).
I don't think you have to fire a gun to have respect for them. Call it fear, call it common sense, call it whatever you want. Semantics.
Like Kelvrick said, there are many people who never develop the proper respect even after firing and owning guns. The people in this news story sure as hell didn't have the proper respect for firearms.
And I'm not fucking stupid enough to leave guns lying around the house where my 10 year old can find them.