Seems to me the ancient rock'n'roll bands all used acoustic bass.
Bill Haley's Comets, Buddy Holly, etc.
Bill Black's playing on Elvis Presley's Sun recordings. No drums.
Just Bill Black's bass.
There are also rock'n'roll revival acts, like the Robert Gordon, Stray Cats, etc
that use acoustic bass.
The best acoustic bass is in the world of jazz. No contest.
But there's nothing stopping you from creating your own lines.
Get Audacity or whatever recorder you like, going. Record a click
track or drums ( Hydrogen ), then thump along with it. Play the tracks
back and see what it sounds like. Double or tripple track yourself,
add effects, etc. Lots of fun. And that's what it should be. Fun.