The story
From the fact that they are powerful (similar to a cannon) yet are easily breakable (similar to glass).
Etymology from Wiktionary, CC BY-SA 4.0.
glass cannon
Today it means: A character or unit with strong offensive power but weak defensive capabilities. Full definition →