No, he is being mourned today by many Americans because he served his country well. Canadians may not mourn any of our leaders.
He was admired by many long before Trump ever mentioned the White House.
There is a long tradition of honoring public servants who have died, whether they are just privates who served in the military, or the Commander-in-Chief.
In times past, that respect has been extended to foes and allies alike in the political spectrum. Men were not reduced to a litmus test on a single issue, be it taxation, environment, social policy, race, hawk/dove, or other.
The policies of G.H.W. Bush were not as progressive as Democrats, but he was no rabid Evangelical, yet had to make his positions in such a way to try to remain in office.
Franklin Roosevelt, Harry Truman, John F Kennedy, and other lionized Democrats would not pass the litmus test of being pro-gay either, but that did not mean they were not distinguished public servants.
If we were not gay men ourselves, it is highly doubtful we would have been as pro-gay in past decades. It is an unfair measure that assumes wisdom gained today was manifest in centuries or decades past.
It's similarly popular to assume that racism existed only in the South when civil rights movements began standing up in the South, yet many Northern and Western areas had (and have) virulent but silent racism. The Boston School Bussing Desegregation happened between 1974 and 1988, long after the foment in the South.
Don't listen to narratives that portray men and places in black and white terms. The Late President was not as progressive of the left, but he was no enemy of gays. He began hate crime tracking which included gay attacks, and he removed sexual deviance from immigration rules which allowed gays to avoid being barred. He was a moderate. He took moderate positions.