The cancellation was swiftly praised by former President Trump, who called it 'great news for America' and commended ABC for 'finally having the courage to do what had to be done'