Yes, Rogan was quite smart to get a real prescription and to get the actual human medical product. CNN (and other news agencies, and people on twitter) were outright foolish in attempting to make him look dumb (he won that round). I am quite irked at the people who thought the way to recommend not taking ivermectin is to shame people.

That said if he is smart enough to anticipate what people are going to say and adjust his actions to negate them, you'd think he'd also be smart enough to see that there really isn't any strong evidence for ivermectin being useful, and it's also possible you can take the drug, have no positive or negative effects, and get better from COVID, even if ivermectin made no difference. From that perspective, thing he did that was bad was "not even being wrong" (https://en.wikipedia.org/wiki/Not_even_wrong) in the sense that we can't say really much of anything about his experience representing a generally useful medical advice.

Rogan is smarter than the average bear, but he's not in the club of the smartest bears.