Welcome. Great to have you with us. Please feel free to share and post all you want.
In Red Wing there is a little park right along the river between the big bridge and the marina. Alot of people will shore fish right along there. The current may be alittle fast right now so another place is at Bay Point in Red Wing. There is a bigger park there and if you take the road that travels towards the bridge that is between the marina on the bridge side [there are 2 marinas] and the river channel you will come to a point. At the end of that point there should be a fishing pier that you can fish from and get out of the fast current. That point points in the direction towards the bridge. Try fishing the current seam [edge of the current and slack water] with a jig and minnow, jig and ringworm, or even a bucktail jig. Good luck and let us know how you do.
Thanks, Bill
ps. I see Chris replied and his locations sound very good. Give them a try.