I dont know if its common because i dont reallh know much about others , but i v had similars dreams where i was a princess , a queen , even some female angel , once i was the mother of like 40 childs lol , others where i was pregnant or giving birth , sometime where i have had peoples consider me a "goddess" , or been the maid of a princess in one too , but yes it always a disapointment for me to wake up too , where i dont want it to end, it feels like waking up in " hell" at times when waking up from theses.