Never said there was not energy transfer, just saying energy isnt what kills.
Your little test only shows what happens to a bullet when it hits something, air isnt something therefore it wont expand. this all comes from the velocity, take the same gun and slow it way down and try it again.