Here's what I came up with, not the most pretty, but it worked, if you put an aspx file name in the title of a content managed site, it will us the title as the url. This way you can easily change the order of the static pages.
siteNavigation.xslt:
<xsl:if test="not(contains(Title,'.aspx'))">
<xsl:attribute name="NavigateUrl">
<xsl:text>~/default.aspx?pageId=</xsl:text>
<xsl:value-of select="PageId"/>
</xsl:attribute>
</xsl:if>
<xsl:if test="contains(Title,'.aspx')">
<xsl:attribute name="NavigateUrl">
<xsl:text>~/</xsl:text>
<xsl:value-of select="Title"/>
</xsl:attribute>
</xsl:if>