[chores] split long running destination tests for nightly builds

[rudolfix]

There are several tests that run very slowly. Most of them are merge and replace tests with various configurations. They are especially slow on lakehouses. What we need to do

1. identify long running tests and move them to separate workflows that we will run nightly
2. make sure that workflows triggered by PR run within 1-2 hours
3. make sure that (2) is more or less covered. it would be good to keep single comprehensive merge and replace tests in there