Now please, nobody laugh..... but, I used to think that this song was about weed.

"Proud Mary" = Mary Jane
Rolling = Being High
never lost sleep worrying what might have been= no worries when you are high