Hey Pythons,
I understand you come to this question with very different premises about human nature, mortality, sin, and salvation/atonement theory than I or traditional Adventists hold. That may help to explain why what I said has offended you.
It seems you've been active in this section a while, so you may be aware that most Adventists hold that only God is immortal; that humans are all mortal and subject to death; that death is an sleep-like state in which one is unaware of knowledge, time, events; and that the saved dead will be raised to receive the gift of life "at the last day." Those beliefs affect the Adventist interpretation of John 11, which you've cited.
From that perspective, an Adventist would agree with you that Lazarus was "asleep" because that is the language Jesus used; he/she would also affirm that Lazarus was dead as a stone -- Jesus stayed 2 extra days after having heard about his sick friend, and then on hearing that he'd died, Jesus saw that his disciples were confused by his language and for their sake "spoke plainly" about the situation: "And after that he saith unto them, Our friend Lazarus sleepeth; but I go, that I may awake him out of sleep. Then said his disciples, Lord, if he sleep, he shall do well. Howbeit Jesus spake of his death: but they thought that he had spoken of taking of rest in sleep. Then said Jesus unto them plainly, Lazarus is dead." (v 11-14) By the time Jesus got to Bethany, Lazarus was four-days dead (v 17) ... long enough for his sister to be worried about how the decomposing corpse would smell. (v 39)
For our purposes, the simple point is that Lazarus died. That section of his story didn't end there, no -- just like it didn't end for the boy that Elisha raised, or the widow's son in Nain, or Jairus' daughter, or Eutychus, or Dorcas. There's no indication in any of those stories that any of the resurrected people were endowed with immortality and so never subsequently died. Not even Matthew confirms that the crowd resurrected when Jesus died didn't die again, and while there are various traditions about what happened to them, those traditions are conjecture. (Again, I understand your premises take you in a different direction.)
But the issue that we've put on the table in this thread is that man is mortal, and so man dies at least once. I agree with you that the death Lazarus faced and was raised from is the first death. Men died before Christ; men still die after Christ; and as such our conclusion is that His ministry here did not eliminate the first death. Had that been his goal or his work, I would not still have funerals to go to. Neither would you.
And so that leaves the second death. All men will fall to the first death and all men will at the last day be raised and judged -- Peter said that even David was dead and still in his Jerusalem tomb after Christ -- but not all men will fall to the second death. Paul's reasoning is that Jesus' work accomplished a great reversal: Since by man came death, by man came also the resurrection of the dead; for as in Adam all die, even so in Christ shall all be made alive. (1 Corinthians 15) Paul, a believer, still died the first death. Though post-Christ, not even he escaped that. The only death left on the table for him to escape was the second death, and he expected that because of Jesus, he would.
Again, though, we differ on premises. If I thought that Christ's death undermined his God-ness but His resurrection proved it, I might be in a spot of trouble here. But I don't think the Bible sustains such a position. I'm by no means forced to allege that He was not righteous -- Bible's clear that He was without sin, and yet God made Him who knew no sin to be sin for us. Though falsely accused and wrongfully convicted, He failed no judgment; in truth He aced the judgment and demonstrated the breadth of God's love and righteousness. I do not have to question whether He is God -- Bible's clear that He is, ever was, and will be.
Blessings and peace to you, bro.