Sirius is definitely dead but not by the spell which hit him. That spell was red in colour which means it was only an expelliarmus spell not the killing curse avada kedavra which is green. He died because he fell through the archway dividing the spirit realm from the world of the living. He's not making any appearances not even in dreams etc.