Weakly motivic Shimura's zeta functions via p-adic L-functions and doubling method