[DOC] Update intro to FixtureAdapter

Update some of the wording. Mentioned that it expects normalized data and a note about it not having a serializer.

Also added a blurb about it being async by default, and how to prevent that with an example.
@igorT ping :smile: