Batteries are what is called DC or direct current.
House wiring is AC or alternating current.
And motion light sensors sold in stores are designed to be run off AC.
You can get an "inverter" which converts DC to house voltage AC.
And then you can keep the batteries charged with a solar panel if this is for a situation where there is no electric power.
And solar electric panel dealers can design a combination solar panel / inverter system which will give you plenty of power for your lights no matter how bright you want them.
The only thing is cost. Solar can be quite expensive, but if there is no power in the area (like out in the woods), it might be less expensive than paying the electric company $40,000.00 to run their lines out there.
But if it is for a shed in your back yard, then having an electrician run a line out there would probably be less expensive than buying a solar setup.
So what specifically do you need this for? How close is the nearest power?
P.S. There is DC lighting like for boats/marine applications. I don't know if you would find any "ready to go" light/motion sensor fixtures though? But also security systems use DC powered motion sensors which could work. But these tend to be expensive. And need quite a bit of electrical knowledge to set up a custom system like that. You could hire someone, but then again there is an added cost.