Dell did not provide "bad" PSUs with their Optiplex 790 MTs. Generally, they are even under-rated. But yes, the OP will need a PSU ugrade to use a RX 570.
@ OP
I am on an Optiplex MT now. A bit newer than yours, but basically the same. I replaced the PSU with a used
Antec 500W Earthwatts PSU and added a
GTX 1070 mini. Also used. I had to go with a mini to keep from covering up the SATA ports. Unfortunately, I don't think there are any mini RX 570s.