Sunday night's ceremony, just a day after Houston was found dead in her Beverly Hills hotel room, began with the tone of a wake