Those guys aren’t primarily glamorous for their defense. All NBA positions are offensive and defensive, point guard isn’t a “Defensive position.”
I’d agree NHL goalie can be glamorous, though at rather enormous cost. Not much glamour in having Brett Hull zing 98-MPH slapshots at your melon.
No, its’ defensive. Defense is preventing scoring, offense is scoring. Pitchers try to prevent scoring.
Pitching is however an active defensive position in a way being a goalie or a defensive end is not, which is one of the reasons it’s a famous position. The other would be that the pitcher simply dominates the outcome of a game; you would be hard pressed to find a position in ANY team sport where a guy can personally dictate a game’s outcome.