“Shredding“ is just one element in an entire package. It by itself is not attractive or unattractive.
Some dirtbag sweeppicking nonstop for a minute and a half over death metal chugging is not going to get any woman’s attention. However, tearing up a guitar in the style of something closer to John Mayer or whatever, over music you can move your ass to, can take an average to decent looking guy who knows how to present himself, like for example he knows not to wear jorts with socks and sandals on stage, over the edge into being very attractive to women. Although I suppose whether that counts as shredding is up to the listener.
It’s advantageous to be able to do both. Both are rewarding in their own ways.