Why did Aemond destroy Sharp Point?

Basically because he’s a spiteful little brat with mommy issues. Sharp Point has no real strategic advantage in the war, but it’s very close to Dragonstone, so it’s likely that he just went to the nearest town to destroy it in a massive fiery temper tantrum after seeing how many dragon’s Rhaenyra (Emma D’Arcy) has on her side.