"Us" as those that stand with our allies, no. Trump is the one making us look bad.
I think its important for us to show a united front. I think many of his actions derailed that. Yes, Trump is of course to blame that too. I think if McCain would have let him come to his funeral, it would have sent a much stronger message to the American people.
That tweet was not needed and just make us look bad. Then again, so are most of Trump's tweets, but no one is arguing that point.
All in all, John McCain lived a great life and served his country with dignity. May he RIP.