Sharon and Charlie's place is great, and I'd very much recommend it. The location is about a 5 minute walk down to the Titans stadium, and then from there you can take the pedestrian bridge over the water (another ~5-10 mins) to Broadway where the strip of bars is. Overall, for the price, I thought the location was fantastic as the walk to everything feels relatively safe and doesn't take too long, without being right in the downtown area. Uber and Lyft also make things simple, as there are plenty of available rides.
As for the inside, it is very well decorated and cozy. There's a very nice bedroom, a small kitchen, a bathroom with a washer and dryer, and a living room with a pull out couch and a tv. If you're expecting something super modern, then this might not be your thing, but I found it quaint and it had everything we needed. The wifi is solid, and while the tv had a bit of a different lineup, it gets the job done, especially since you're likely not visiting Nashville to just watch tv.
Charlie reached out the day of to see what our plans were, and he always quickly responded. We didn't really have to ask too many questions, as I had a gameplan for the trip already, although I feel like Charlie would've been very helpful had we had any questions. He was very nice, and the place was full stocked with the normal stuff you need - including a few bags of chips he left out for us. Great hosts.
Overall, if you're looking for a reasonably priced, cool place to stay at during your trip, I'd feel confident recommending it. Just make sure you won't have any issues getting up the stairs. Oh, and catch a Predators game while you're there. The local fans are great and don't disappoint!