On second read, it is more of a Gaps-and-Islands problem

Example or dbFiddle

with cte as (
Select [Sort]
      ,[Status]
      ,Grp = row_number() over (order by Sort)
            -row_number() over (partition by [Status] order by Sort)
 From YourTable
 )
 Select top 1 
        [Status]
       ,Times = sum(1)
  From  cte
  Group By Grp,[Status]
  Order by max([Sort]) desc

Results

Status  Times
alpha   3

you can use window function(lead and First_value for find Times

select Status LastStatus,times
from (
        select 
              Status
            ,lastvalue- First_value(sort) over(order by  lg desc   ) +1  
            as times
            ,sort
             ,row_number() over (order by Sort desc) as rw
        from (
                select *,

                    max(Sort) over (order by Sort desc) as lastvalue,
                    Last_value(Status) over (order by Sort desc) as lastStatus,

                     case when 
                     lead(Status) over(order by sort desc)!=Status then 1 else 0 end as lg
                 from L
        )a
        where lg=1
    
)a
where rw=1

The solution below gets the number of the last row in the last sequence of the Status value using only descending sort.

SELECT TOP 1
  [status] AS [LastStatus],
  ROW_NUMBER() OVER (ORDER BY [Sort] DESC) AS [Times]
FROM t
ORDER BY
  ROW_NUMBER() OVER (ORDER BY [Sort] DESC) 
    - ROW_NUMBER() OVER (PARTITION BY [Status] ORDER BY [Sort] DESC),
  [Times] DESC

db<>fiddle