I understand that your concern is that the scripture makes it appear that when the Lord is revealed from heaven in blazing fire, that at that time He gives us relief which would infer that we will be on the earth when He returns so that we can receive His rest and be avenged. However, and without going over every detail, I would draw your attention to what I have highlighted in red when Paul says "and to us as well." So the question is, how could the Lord give rest to Paul and those with him who have already died, since the Lord has yet to be revealed from heaven in blazing fire with His holy angels? Therefore, he must have another meaning in mind or he may be generalizing. Just something to consider
1 Corinthians 15:51-53 King James Version (KJV) Behold, I shew you a mystery; We shall not all sleep, but we shall all be changed, In a moment, in the twinkling of an eye, at the last trump: for the trumpet shall sound, and the dead shall be raised incorruptible, and we shall be changed. For this corruptible must put on incorruption, and this mortal must put on immortality.
There will not be a mixture of corruptible bodies (dead) and incorruptible bodies walking around at the same time. Sounds more like Hollywood today .