Army secretary's resignation follows months of tensions with US Defense Secretary Pete Hegseth, US media reports say.