The Providence(provi) is one of the coolest looking ships in the entire Star Wars lore, from its long pointed nose and mouth looking bit on the front to its (seemingly unprotected) observation deck elevated above the ship. I have now flown a provi a little less than a handful of times, and I can say I am extremely excited to fly it some more.
It can be useful as many different things. It can be a carrier or a gunship, maybe even a super hard-to-kill points fortress a la HMC80 Assault. I think, however, if you're not building it to be defensive, then it goes down pretty damn easy. 5/3/2 and 9 hull points ain't nothing, but I think it has a pretty subpar token suite lacking anything redundant like the Venator.
While not being hugely defensive, I believe it is a mighty offensive ship. Even without what might seem like the necessary upgrades, it can put out some major hurt, whether that's from the native 4 squads you can toss or from the eleven dice it gets on a close-range double arc. I still have to play around with it some more before making too many presumptions, but so far, I love it.