well, that is an angle i haven't considered before. i assumed the idea is that he'd turn to stone and his conciousness cease to exist, but if he becomes a living statue then that's far more concerning. as for the gods, i think reading to the end of the current build will give you a better understanding.

It's possible for Asterion to have children, in theory. The closest example is Storm, his mom was human and we don't know what his dad was but as P stated, his father and grandfather were both peacocks. We also see Khenbish's father, and I can only interpret that his other siblings are boar-like, since he stated that they needed passports (charms) as well. This might be different for each mythical, since Kota did not have parents, instead, he was brought to life through belief like other deities, such as the skinned tapir you find in The Hinterlands. It is not known whether or not Kota still has followers or he simply became mortal? Perhaps that is explained somewhere. 

I'm not completely sure about Asterion's sexuality, but it could be possible if he were to conceive with a women. However, one of the hotel's contracts do not permit Asterion to develop relationships with guests. What that exactly entails in terms of intercouse, I do not know.

The devs highly encourage doing some detective work to find answers to questions like these. Although, I don't really care about finding answers that I don't know are there.

What do you mean when you say 'Death'? It's been a bit since I've played through the game so I might have just forgotten about it?...

I've been wondering if that scene in the original labyrinth under the stars where Asterion gets his star back, if that isn't him becoming divine. He is technically a demigod, right?... So perhaps that scene was him redeeming himself for the supposed 'cowardice' at the hands of Theseus?