📝 Fix async example in `session.execute()` docstring & deprecation message

[DanielLeviLucas]

This PR fixes a mistake in docstring and deprecation message of AsyncSession.execute() (we should await execute method and only then call scalars):

heroes = await session.execute(select(Hero)).scalars().all()