Tom Waits has some unconventional ones
*Christmas Card From a Hooker in Minneapolis
Pasties and a G-String* is about strippers.
Step Right Up is about a huckster/con man
Calypso - John Denver, is a tribute to his good friend and ocean researcher Jacques Cousteau and his ship Calypso.
Abraham, Martin and John - Dion, about two presidents and a civil rights activist.
Damn, beat me to it!
Charlotte the Harlot by Iron Maiden. Charlotte is a prostitute.
A number of songs have been written about Casey Jones the train driver. Here are a couple:
The Police Roxanne prostitute, Don’t Stand so Close to Me young teacher.
Traveling Wilburys Tweeter and the Monkey Man undercover cop, racketeer, etc.
Steve Miller Band Take the Money and Run detective.
And Mr. Mustard’s sister Polythene Pam works in a shop, although they don’t mention her exact job.
Maxwell Edison is a medical student. “Maxwell’s Silver Hammer” also mentions a teacher, policeman, and judge, though they don’t have names.
A bartender, in Bartender’s Blues.
And, well, unemployed, but he loves to work at nothing all day.
Little Feat - Willin’
(and a thousand others)
Belle And Sebastian - Dear Catastrophe Waitress
The Wreck of the Edmund Fitzgerald - commercial sailors
16 Tons - coal miner
Band On The Run - County judge, Sailor Sam, jailer man
Rocketman, and a few others - astronaut
Right Said Fred “I’m Too Sexy”
The narrator of Louie Louie, to the extent he can be comprehended, seems to be a sailor.
The crew of The Sloop John B are sailors but appear to spend most their time drunk.
New Order’s “Love Vigilantes” is about a soldier.
Getting back to Weird Al, the second verse of “Headline News” is about rival ice skaters Tonya Harding and Nancy Kerrigan.
And by Mississippi John Hurt
More Beatles: Sgt. Pepper was a band leader.
NWA Dopeman, Fck tha Police* both obvious.
Desmond has a barrow in the marketplace.
Molly is a singer in a band.
Tim Hardin - If I Were A Carpenter
The Rolling Stones’ You Got Me Rocking has a bunch:
A butcher
A surgeon
A pitcher
A fighter
A boxer
A hooker
A writer
A tycoon
Coming into Los Angeles: a customs man
And a dealer.
You could be The greatest coal miner of all, Big Bad John
Or simply Working in the Coal Mine
Or shovel Sixteen Tons of coal
Or even be a Coal Miner’s Daughter