I just learned of this one, but I heard the meaning is more akin to “damn”

Honest question from a USian: is the Eurovision competition honestly a big thing with most people or is this hyped up by the media? For example, is this basically like America’s Got Talent, about which no one I know cares, or is this actually a big deal with the common pleb?