Is there any way to upcycle a swimming pool pump?

How about make into a bird bath or fountain.

Hi Jenaffer, it is like a large one then, you could use it in a new water feature in your yard like a pond with a waterfall going into it, a pool pump would have the power to do that.

https://www.hunker.com/13425498/how-to-use-a-pool-pump-for-a-pond

Tilapia pond. Eat those fish. Make that water useful.

Jenaffer, here are some unique ideas that you might find useful: https://www.hometalk.com/diy/-1431253

https://www.hometalk.com/diy/greek-fountain-442637

https://www.hometalk.com/diy/outdoor/garden/winter-fire-pit-summer-fountain-2547400

Does the pump still work properly?

Instead of spending money trying to 'transform' it, I would suggest to sell it, then use the money for a project that you really do want to try.