at the end of the card it says the card is saet in its spell and trap card zone during your opponents end phase. does this mean its set even after its being destroyed?

No. The card will be sent to the graveyard if destroyed.