There are multiple ways of measuring the strength of a material (tension, compression, deformation, shear, yield strength, etc), and they can depend on the shape of the material for how they apply, as well as how the system they are used in is designed overall. You can look up the charts for specific alloys of varying materials to see which ways each one is stronger than other materials. Like anything else, CF is strong in particular ways, and not as much so in others. As with any other material, this is true not just as a raw material, but even when it is assembled correctly for the design intent.
With CF it also depends not only on the CF itself, but on the bonding material and molding and curing process used to make the fibers into a "solid" material, and the methods used to weave or otherwise make the fibers into a mat, etc. Similarly the alloying and casting and drawing processes for metals affect their actual strength in a particular usage.
Frames (of any kind, but bicycle ones specifically in this discussion) are designed in general to take certain kinds of stresses in certain directions, and any strength they have against other kinds of stresses in other directions is coincidental and may be insufficient.
Whether or not a particular frame handles a particular non-designed-for load would have to be tested under the conditions it would need to function in to be sure it couldn't fail from that load.