Is the PREMISE exciting? Is the idea of a prequel that could tell a tale of the foundations for the future exciting?
Yeah, that premise is very exciting (potentially; any premise could be bungled). But that isn't the premise of ENT so far.
The premise of ENT is "watch Archer & co wander around randomly and discover stuff and then fly away." And no, that premise isn't very interesting. Plus, it was done to death on TOS and TNG (which had the added premise of "watch Kirk/Picard patrol and defend the Federation," a much more inherently interesting premise) and it was the defacto premise of VOY, so to say it's been DONE is an understatement.
The 24th C isn't what's been done to death (a time period isn't a premise anyway); the random-exploration premise HAS.
You already know how it's going to end--the formation of the Federation. All this series is doing is connecting the dots (yawn).

Ah, this takes me back to the olden days, months before ENT premiered, before we even had an
ENT Forum and we had these debates in
Future of Trek instead...that was actually the chief objection to the BOTF premise as I recall...I wondered whatever happened to those folks anyway?
The obvious rebuttal to this idea is that in
Gone With the Wind, we know how the Civil War ends; in
Band of Brothers, the BEST thing I've ever seen on TV, we know how WWII ends; but knowing how the larger political framework ends up doesn't make it any less interesting to see the smaller, personal stories a few people who live in those fascinating times.
A ficitonal story about the Civil War is never actually about the Civil War; that would be a documentary. The story is about a few people who live during, and are affected by, the Civil War. The fact that the North wins the war tells us nothing about whether Rhett and Scarlett will find happiness, live or die, end up rich or poor, or whatever. So their stories are still interesting (as long as they're interesting, believable people with which we can identify to some extent, and who have something driving them so that they can drive the plot).
But anyone who thinks great movies like Glory and Lawrence of Arabia are "boring" obviously isn't on the same wavelength as me. Or even a not-so-hot but fun, rabble-rousing movie like Braveheart. There are thousnads of historical novels and films, so obviously a whole hell of a lot of people have no objection to stories set against a backdrop where the larger political result is known, but the individual characters' fates are NOT known.
Besides, knowing that the North won the war, how could you know all the soldiers in Glory would die? They're Union soldiers. You couldn't possibly know how the story ends!!!