There are many potential advantages of celecoxib, as a "selective" COX-2 inhibitor, over non-selective NSAIDs. Because of the lesser inhibition of platelet function, it has potential advantages in the peri-operative period, in patients with bleeding disorders or taking anti-thrombotic or anti-coagul...

Yes

The main benefit of COX-2 drugs is on gastric toxicity and not selectively avoiding other problems such as fluid retention, raising BP, and of course, negatively affecting renal function.

Of course, I would prefer to avoid all NSAIDs with CKD but many patients benefit from anti-inflammatory effects and options to help are limited. I have had many patients tolerate ongoing use as they felt they had little choice.