[ContentManager] Non-XNB asset path normalization accuracy

- Make paths for non-XNB assets relateve to program directory.
- Allow RootDirectory to be set to an absolute path.