[FLINK-8586][tests] Clean up hard to maintain tests
SpilledSubpartitionViewTest duplicates a lot of production logic
(TestSubpartitionConsumer is a
duplicated logic of LocalInputChannel and mix of
CreditBasedSequenceNumberingViewReader with PartitionRequestQueue.
Also it seems like most of the logic is covered by SpillableSubpartitionTest.