does it have to be the player's 'main' body that dies on the quest bed, and their dream body that goes god tier? or does it work either way, as long as one body dies on the quest bed and the other is still alive?

It’s the main body that has to die on the Quest Bed and the dream body ascends.