I'm not the best at this so this was probably obvious. As a self-contained app you must put both the Xaml and the xbf file in the executable directory. As an aside. For everyone asking about plugins but never getting an answer, use WINRT_IMPL_LoadLibraryW and WINRT_IMPL_GetProcAddress and pass it the typename value to get the IActivationFactory and ask for a MUXC::Page. With the Xaml and the xbf in the executable folder, a BlankPage template example works fine in my test. I can't seem to get TypeName to work with the app.manifest without actually referencing the module.
[just my observations]