If you do it incorrectly and fail, then yes, you would be in a lot of pain and potentially survive with serious and debilitating injuries. However, like others have said, if done correctly then death would be pretty much guaranteed, instantaneous and painless (you wouldn't even feel anything or hear the gunshot go off as you'll be dead so quickly that you wouldn't be able to process it).