Your intuition is insightful. In fact to factors enter at play: the speed of sound in the medium and the attenuation of sound in the medium.
Speed of Sound: As you correctly noted, the speed of sound is much higher in metals than in air. This is because sound waves are mechanical waves and require a medium to propagate. In solids, where atoms/molecules are densely packed, sound waves can propagate faster because neighboring atoms/molecules can quickly transmit the wave's energy.
Attenuation of Sound: This is where things become interesting. Attenuation refers to how much the sound wave diminishes (loses energy or amplitude) as it travels. The attenuation of sound in a medium depends on several factors, including the frequency of the sound, the properties of the medium (like its density and elasticity), and the presence of any obstacles or defects in the medium.
Now, to your question: Would sound get weaker in metal faster than in air over the same distance?
The answer is not straightforward because it depends on the specific conditions, especially the frequency of the sound and the specific properties of the metal and the air. Generally, at normal frequencies, the attenuation of sound is less in air than in many metals, so sound can indeed travel farther in air without losing as much of its energy. This is due in part to the mechanisms of sound attenuation in metals, which include scattering of the sound waves from defects in the metal and thermal conduction, both of which can cause the sound wave to lose energy. In solids, sound waves interact with the lattice structure of the solid, which can cause scattering and conversion of sound energy into other forms, leading to attenuation. Gases, being less dense and less structured, usually provide less resistance to the propagation of sound waves, leading to lower attenuation. However, materials science is pretty advanced and perhaps there is some way to create a given metal that would resonate and don't damp certain frequencies.
As an aside note about the weakness you would have in metal, note that even though sound might be attenuated more in metal than in air over a given distance, the sound wave can still carry more information or be more "recognizable" when it arrives because of the higher speed of sound in metal, which can preserve the shape of the wave better than the slower speed of sound in air.
In conclusion, while the speed of sound in metals is higher, the attenuation can also be higher, which means that sound can lose energy more quickly in metals than in air. But the specific outcomes can depend on many factors and are not easy to predict without more detailed information.
If the answer is longer than necessary I invite the community to actively change it.