How to get author_picture URL from a template?
URL FORMATTER module

This module add a url formatter for image field. Then you can output image url directly.

Once enabled, go to your user manage fields, and change the picture field formatter to url.
{{ author_picture }}  // will display url instead of picture

If you are using views, views will give you an option to change the format to url.