A lot of ska bands have some really killer trumpet parts. As for rock and pop, trumpet isn't the main thing so much as it is an added color in the background of the singers. There's a reason that most rock and pop bands don't get started by trumpet players
Some genres just don't have a big place for certain instruments. How many concert bands have a guitar or a singer at all? I'm just glad that trumpet is as versatile as it is and can at least play a small part in so many different types of music.