[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.
The concept of sideloading doesn't really apply to fixtures so I am a bit confused but this comment?