Profile edit can only be displayed as Flat or Tabbed. It can not be displayed as both. This can be changed within CB > Configuration > User Profile by adjusting "Profile Edit Layout". Profile edit tab ordering is based off tab position and tab profile ordering. It's not possible to have a profile edit order separate from profile display at this time.
Another question: How do I make the tabs in Edit field red or something so that even the most inattentive can spot it? You wouldnt believe the questions I am sometimes getting...
Edit your tab within CB > Tab Management then add a CSS class to the "CSS Class" parameter. This will be added to your tab, which you can then use custom styling to style.
CB Query is also not a desired option where you query the database for the input that people put in under canvas to display them only on the frontend using CB Query as I am trying to keep the queries to an absolute minimum.
You don't need an extra query. Just use Custom HTML field and substitute in the fields display. See the below substitution usage tutorial.
www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb