It's a "dramma giocosa," a merry drama. Da Ponte agreed with you on the death not being tragic; the show premiered with the title "The Rake, Punished," indicating what he thought of Giovanni and his end.