Update testing for drop compact storage and CASSANDRA-15897

As observed in CASSANDRA-17869 we need to update drop compact storage tests

DropCompactStorageTest java distributed test does not verify that compact drop is not possible before upgradesstables. This we do in the python test drop_compact storage.

The python test drop_compact_storage tests also CASSANDRA-15897

Though the test is not multi-step upgrade test. It would make no sense for it be 3.x to 5.x (which we don't support).

But still we need to ensure we still verify things in the newer Cassandra versions as compact storage is still around; tests need to be updated to cover CASSANDRA-15897