Hmmm... I would mostly like this if it were just slightly less restrictive. Specifically, I'd like my nonhousehold immediate family to be able to come and go.

If anyone thinks this is just going to one day be suddenly over they are deluded to a Tumpesque level of doolally tap.
In the absences of a vaccine or a cure this disease will require social distancing to be the norm for some years, with periodic nation and local lock downs when and where necessary.
Bare in mind we do not have cures for all sorts of viral infections from AIDS to the common cold despite decades of study and experimentation.
This disease is something we will literally have to live with, for some time.
"What cannot be cured must be endured" Robert Burton The Anatomy of Melancholy

"There are still many things we don’t understand about SARS-CoV-2, like immunity; if immunity to the virus isn’t permanent, it is more likely to become an illness that regularly circulates through the population like the flu."

I know how you hate the comparison of Covid-19 with the flu.

I already like to keep social contacts minimal, yet social distancing may put a cramp in my lifestyle. I do feel compelled to get away from the usual, so I don't know how I will react to that limitation. Hopefully in a wonderfully creative way.

And Anderson Cooper (CNN) just said this should make introverts happy, while claiming to be one. Ha! He said introverts will just prefer to have Zoom relationships (sorry, not THIS introvert). I may be happy to live on a hill in a rural mountainous area of West Virginia beyond the cell signal, but social distancing just sucks. I'll be more selective about crowds, be delighted to not attend business lunches and dinners and relish the excuse to stay away from other group functions... but I do like some people, like to dance and would miss meeting new people. I'll work around it.