Bassbaron,
Been there, so I know it really sucks.
I have had success with dragging a metal clip type stringer, with the clips open. We snagged the line and were able to retrieve the rod that way.
If that doesn’t work, and since it is realatively shallow, you might try a pole with some sort of hooks on the end of it. I’m not talking about fishing hooks, just bent pieces of metal that are not sharp. A cut up cloths hanger and duct tape might do it.
A great pole for this would be the kind used to clean pools. Try to borrow one because they are pretty expensive.
Another Idea for the pole would be an extendable golf ball or lure retriever.
As a last resort, contact your local SCUBA club or volunteer fire department’s search and rescue unit.
They may be looking for a challenge or training oportunity. I had a friend loose a wedding ring at a boat landing and the local search and rescue team volunteered to look for it.
Good luck,
Steve