Yes, it can. If you look at the
Resolving Abilities section of the rules, it says that you resolve abilities as fully as possible, and if an ability cannot resolve completely, any unresolved portion of that ability has no effect.
Since the Target of
Ooh, Shiny! just says "your Hero card" and doesn't specify that the Hero must be zapped, it is still a valid target of the ability, even if it cannot resolve.