docs: Document built-in tap and target tests

[edgarrmondragon]

Documentation type

Reference

Description

https://sdk.meltano.com/en/v0.40.0/testing.html has examples and references for the public API, but we could use a description of what each test does.