While I disagree with your assertion that Honnold isn't "ripped" (a word for which we seem to have different definitions) it is worth noting that the primary muscles(/tendons) used in climbing are hand/forearm based and you can do quite well even with everything else being significantly weaker in comparison.