Metal is way more expensive but will outlive all of us with little trouble. There are barns, and some houses, in SoMD that the metal roofs are over a hundred years old.
A downside, even with good sound insulation, is noise. The house behind me got a metal roof several years ago and hearing the acorns from the oak tree fall on it was entertaining, and that was from the outside. Then the owner butc..........errr trimmed the oak back.
I would have gotten metal when we replaced our roof several years ago but the price difference was significant (5 or 6 time more than asphalt shingles).