Are crossbows especially helpful to Pueblo dwellers?
I would say so, especially in terms of ergonomics. Something I explored in my Amerindian timeline as well. Though bows remained popular for siege defence in the Old World, crossbows were especially popular for shooting over parapet walls (often between merlons) or from arrowslits in walls an towers precisely because they're less akward to hold while you're shooting. You can't really shoot well horizontally from a bow, especially not when you want to aim with at least some accuracy. The crossbow solves the issue. Doesn't get in the way while shooting downward at attackers, is quite a bit easier to aim with, and there's also the fact you can span the crossbow, place your bolt, wait as long as you need, and then release. Regardless of what mechanism they use in Medieval America (in my timeline, the natives used the simplest mechanisms, with a groove for the string and simple lever-triggers to lift it, purely because they have Neolithic tech only in the pre-Columbian period, i.e. no metallurgy), a crossbow could be pretty valuable to cultures that have towns and forts with proper thick masonry and adobe, as a practical defensive weapon. Yes, they can use bows, but those are more finnicky to work with in siege defence. They could use slings and javelins, but those are far less precise than archery weapons (and throwing a javelin away is just wasteful in a siege). Additionally, crossbow bolts can be manufactured in a way that avoids their fletching deteriorating as easily as the fletching of regular longer arrows.
If guns don't exist, crossbows will be king. They're also easier to gain proficiency with for complete newbies who usually don't use ranged weaponry. Ideal for homestead defence, pueblo defence, or for shooting at any dangerous wildlife that's pestering your dwelling. Also makes it easier to do some hunting near your domicile, if all you want to shoot is a bird, a jackrabbit/hare or some small deer.
I'd be actually shocked if Medieval America's technology was overly primitive when it comes to knowledge and skills of mechanical ranged weaponry. Especially if iron and steel metallurgy is known and Medieval America can manufacture good quality steel weapons and armour and other contraptions. They'll be able to manufacture even good quality steel parts, and an adequate crossbow suitable for hunting or for military purposes, doesn't even need steel parts at all. Today, there's still an Appalachian crossbow-building tradition that goes back to colonial times, plenty of Americans today also build hobbyist crossbows at home or buy modern models for hunting. Some knowledge of the crossbow, at least up to an 17th-18th century level (or a few centuries earlier) would survive in Medieval America, even if no knowledge of present day modern crossbows survived. (Given that guns are lost tech, I'd say all MA crossbows will be up to roughly the Renaissance level, at most, with a few minor accessory anachronisms here and there.) You can bet your belly button that as soon as firearm knowledge was lost in the past, the successor cultures in the Appalachians returned to making crossbows
en masse. An old folk tradition that nearly disappeared by the 20th century, but came in handy once firearm technology became forgotten.