Even some Republicans have called president’s public demand to remove the painting ‘petty’