I'm not a big fan of the Constitution III-class design at all. In fact, I can honestly say I dislike it both inside and out. I much prefer the Odyssey-class, and while that design has a number of detractors on this board, I have my knives pointed at the Constitution III-class, so there.
![Razz :razz: :razz:](/styles/flatawesome/xenforo/smilies/razzberry.gif)
Thing looks like someone stepped on it before it was even finished. I know some work went into it, but that makes it even more tragic because I've seen other fan-made designs that were better homages to the Constitution- and Constitution II-classes, yet still were obviously post-VOY.
I wish it had been the
Enterprise-E that was decommissioned after Frontier Day and it was the
Enterprise-F that replaced her. That made more sense to me, and it was actually what I expected to happen after seeing the initial trailers for PIC's third season. What we actually got was contrived and convoluted fanfiction made official.
As far as being the Federation flagship, only the
Enterprise-D was ever called that. For all we know, she was the only
Enterprise to have that unique title and it went to another vessel after her demise (or rather decommissioning).