I think being a monarch as prominent as Queen Elizabeth is a hard job mostly because there is very little you can do right and a whole lot you could do wrong. She avoided doing much wrong for her reign and I think she was an ideal monarch for the modern democratic age.
That said, I think his statement is not quite accurate. Very few people are aware of (or think about) the monarchy at all, and of the ones that are, very few of them actually care one way or the other about it. Of those, I'm sure most agree that the monarchy is pointless, but unlike in the UK we don't spend a whole lot of money on it so in reality no one really cares much except on principle.
Which makes sense, to me. The Canadian experience of the world wars and subsequent decades was decidedly different than the British experience, and the role that Elizabeth played, though meaningful, wasn't as important to our cultural identity. But now that those wars are generations past, and both nations have enjoyed relative peace and comfort for some decades, the sentiments toward the monarchy are beginning to align.
0: https://bc.ctvnews.ca/canadian-support-for-monarchy-hits-low...
1: https://www.statista.com/statistics/863893/support-for-the-m...