With all due respect, I think every answer so far has missed the mark somewhat.
First of all, based on the Context section of your question ...
Before deleting an album, the user is asked to confirm the action.
... we can deduce that this is not a success or error modal, but rather it is a confirmation modal, which implies a warning or caution color like yellow, not green or red, as success and error colors imply respectively. And since it is a confirmation modal, the wording should probably change to something like:
Please confirm the deletion of this album:
To further the usability of the confirmation modal, you can embolden the Confirm button to make it stand out just a bit more. And for those that have color blindness or reading issues, I typically put an icon matching what is being confirmed. In this case, a trash can seems to fit.
When you add all that together, here is an example of what you get: