As per my knowledge, Marianne Granum was the in charge of this program. In case this has changed, could someone please inform us all who is actually in charge here? I had sent an e-mail with my application details to Quim Gil as well, and am yet to receive an update on the same.

See my post just before yours. Knut Yrvin is now in charge of the Qt Ambassador program (he stated that explicitly in an email I received from him on 25 June 2012) and I have had no issues communicating with him via the official ambassador email address (although, as I also mentioned, they are extremely busy and each communication cycle takes time).

Has anyone got N9 after Marianne Granum left? Is this program dead?

Qt are not Nokia property presently. So, yes, Nokia Qt Ambassador program is dead.
But here [qt.digia.com] Digia gave promise start new Ambassador program as soon as possible