Why do muscles get tired if ATP is only required for the myosin head to be released?

That, and your body does require the muscles to work to keep your hand up. Just like our core muscles are always holding us up. Also muscles require glucose to work, and eventually you run short. But it's mainly that muscles that are not usually actively engaged are being actively engaged