For the most part you include static tabs perfectly fine, but some of them likely won't work properly. Especially tabs with posting capabilities as they'll send the user to their CB profile on post. You also don't need PHP in an article for this. Install our CB Content Bot, which allows substitutions in a Joomla article, then use the below tutorials for substitutions to add tabs/fields to the article as needed.
www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb
www.joomlapolis.com/support/tutorials/107-use-cases/18354-substituting-tabs-as-fields
For custom profiles you should use tab positions and CSS to have the layout you want. You can also modify CBs template PHP file below as needed. You can also try looking into CB Profile Pro which allows customizing the profile, but there's mixed results with it.
/components/com_comprofiler/plugin/templates/default/default.php