Let extend me my comment to an answer.
In the package documentation, page 87, is about ybar interval stated:
There is one conceptional difference when working with intervals: an
interval is defined by two coordinates. Since ybar has one value for
each interval, the ith bar is defined by
- the y value of the ith coordinates,
- the x value of the ith coordinate as left interval boundary,
- the x value of the (i + 1)th coordinate as right interval boundary.
Consequently, there is one coordinate too much: the last coordinate will only be used to determine the interval width; its y value doesn’t
influence the bar appearance.
Regarding this, your image, that in case should have four interval bars need additional coordinate for determining last interval. In it is important x-coordinate, , y can be doomy:
\documentclass[twocolumn, a4paper]{article}
\usepackage{pgfplots}
\pgfplotsset{compat=1.18}
\begin{document}
\begin{figure}
\begin{tikzpicture}
\begin{semilogxaxis}[xlabel=Number of Active Satellites, ylabel=Frequency]
\addplot[color=red, ybar interval]
plot coordinates {(5.5,856) (55,110) (550,14) (5500,122)
(55000,0)}; % <--- dummy y vale, just determine last interwal width
\end{semilogxaxis}
\end{tikzpicture}
\caption{Number of active satellites controlled by operator}
\label{fig:satellitesbyoperatorhisto}
\end{figure}
\end{document}

ybar interval
and addybar
.ybar interval
because it's a histogram. If I just useybar
I get the 4 bars but with unwanted gaps between them. I think I may have misunderstood howybar interval
works